We converted from Access 97 to Access 2010.
Error received when running queries with the converted Access database using User1's system…
[Microsoft][ODBC SQL Server Driver] Communication Link Failure (#0)
When the same queries are run from User 2's system the error does not occur.
This message also came up when doing the conversion...
-3831: The current file format no longer supports user-level security. The conversion or compaction process has removed any user-level permissions.
When the 1st user runs the queries using the mdb DB works fine.
When using the accdb DB error occurs.
Any ideas on what is causing this?