open project using existing data

C

cornelia

Hi there,

Problem:
The new project is being open from our SQL database using
the "Open project from existing data" option.
When trying to view a table ("open") in datasheet view, I
am getting the error "Cannot find column "ColumnName"."

What happened:
This column name used to exist in the sql table, but was
deleted.

Question:
Why is Access still looking for that column. Does the
schema still persists somewhere?
Quering the SQL information_schema did not return this
column name anywhere in our database.

Tries:
Added the column in SQL to the table. (It opened fine in
Access.)
Deleted the column from within the Access project. (Error
persists)
Applied the latest jet engine service pack. (no change)

Please help!
Thank you.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top