I am getting a very strange ODBC error, when connecting to a SQL database.
There already was an MS Access DB, connected correctly to a SQL back-end. I copied this database, removed the ODBC links, then re-linked to the new SQL database correctly (or was done in the past). I could see the data correctly, but my users could not.
Test, test, test...
So we have come down to this situation.
I have used the new MS Access database (front-end) that was giving the ODBC errros. I then connected to the old SQL database, the very same way it was connected before. So, the users should still see the data. It uses the very same File DSN connection, to connect to the very same SQL Server, same database, and same tables.
For some odd reason, in the new MS Access DB, the users STILL get the ODBC error. Even though, the connection is exactly the same as another MS Access DB that works correctly for them.
Could something within the MS Access DB cause ODBC errors? Where I use the very same database/tables and DSN file. But the only difference is the MS Access DB?
Thank you,
TJ Bernard
There already was an MS Access DB, connected correctly to a SQL back-end. I copied this database, removed the ODBC links, then re-linked to the new SQL database correctly (or was done in the past). I could see the data correctly, but my users could not.
Test, test, test...
So we have come down to this situation.
I have used the new MS Access database (front-end) that was giving the ODBC errros. I then connected to the old SQL database, the very same way it was connected before. So, the users should still see the data. It uses the very same File DSN connection, to connect to the very same SQL Server, same database, and same tables.
For some odd reason, in the new MS Access DB, the users STILL get the ODBC error. Even though, the connection is exactly the same as another MS Access DB that works correctly for them.
Could something within the MS Access DB cause ODBC errors? Where I use the very same database/tables and DSN file. But the only difference is the MS Access DB?
Thank you,
TJ Bernard
