I am trying to access an Access 2000 DB with ADO that is restricted by a Security file. No matter what I do I can't Open the DB. If I create a DSN it works, but then when the Queries in that DB (which I am referencing in my SQL string) access table/queries in another DB I hit the same wall again. How do I establish a connection to a secured DB and how can I get Jet to stop giving me exclusive access errors?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Jet > ADO and Security
- Thread starter beruken
- Start date
Do you have an access mdb open for design (creating vba code, etc..) and are you establishing a second connection to this mdb?
1. Are you in mdb 1?
2. Trying to make a connection to mdb 2?
3. Trying to make a connection to mdb 1 with linked tables to mdb2?
Most helpful if you show your query along with the definitions, connection string, etc..
1. Are you in mdb 1?
2. Trying to make a connection to mdb 2?
3. Trying to make a connection to mdb 1 with linked tables to mdb2?
Most helpful if you show your query along with the definitions, connection string, etc..
- Status
Similar threads
- Locked
- Question
- Locked
- Question
