ODBC Call Failed - End Users

[paulS30berks]

I am running Access as a front end to SQL and maintain all reports and forms from a .mdb. I then release an .mde to a different location for end users to use.

Each time I release an .mde and a user attempts to run a report an "ODBC call failed" error appears. So I have to re-link tables on users pc's. The Users ODBC connections are set up the same as mine.

Has anyone any ideas why this may be happening?

Thanks

Paul

 

[KevCB226]

If you are sure that your connections are exactly the same, then it sounds like you will need to refresh the table links whenever the database is opened.

I created some code behind a form a while ago that will do this, which I have attatched. You just need to set the username, password and server name etc of your SQL server in the code, and make sure that the form is set to run when the database is opened.

Note: This also works for Oracle databases as well and may throw up an error, if so just delete the Oracle bit.