Solved

Access 97 to Access 2010 conversion

Posted on 2011-03-16
2
1,031 Views
Last Modified: 2012-05-11
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?
0
Comment
Question by:tesla764
2 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 35150315
"The current file format no longer supports user-level security."

Well, that is the case.  ULS was removed starting in A2007 (and A2010).  So ... the ACCDB format does not support ULS.  But ... you can ... still run an MDB with ULS in the A2007 environment.

mx
0
 

Author Closing Comment

by:tesla764
ID: 35150444
I am looking for more info about the ODBC connection error.
Thanks.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Trying to open FORM in specific record !! 6 45
Question about DB Schema 27 56
Create macro from runcode 30 26
SQL multicriteria from ONE textbox 32 43
There are several problems reported according slow link speeds or poor performance in TMG 2010, UAG 2010 or ISA 2006. I want to collect here some of the common issues together to give a brief overview what can be the reason. Nevertheless, not all of…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question