Linking to a table in a secured database

[hickeyc]

I have two access databases where db1 needs to link to a table in db2. There was a linked table set up and working but then I needed to turn on security in db2. Now when I try to open the table in db1 it says I don't have permission.

How do I set up the security in either db1 or db2 so that I can link to the tables in db2? I'm thinking there must be a way to specify the security file and/or a user name and password when I create the link but I can't find a way to do it.

Thanks for any help.

 

[sfreeman]

Delete the link, and then re-establish the link to the secured db, and you will be prompted for the password.

Sam_F
"90% of the problem is asking the right question.

 

[hickeyc]

Thanks, but when I tried to Link tables and select the mdb file it says that I do not have the necessary permissions to access the database. I never get prompted for a password.

I tried both New Table | Link Table and Get External Data | Link Table (which I assume are the same thing), then browse to the secured mdb file and select it to open. Is there something else I should be doing?

 

[Hap007]

Dear hickeyc,

Well, you need to start Access using the security file that is correct for the backend.

----------------------------------------------------------
Here is a sample line from the properties tab of a shortcut that will start access:

"C:\Program Files\Office2K\Office\MSACCESS.EXE" /excl /wrkgrp "C:\PROGRAM FILES\The Program Directory\TheSecurity.mdw"

---------------------------------------------------------
Here is a sample line from the properties tab of a shortcut that will start access and your Frontend program:
"C:\Program Files\Office2K\Office\MSACCESS.EXE" /excl /wrkgrp "C:\PROGRAM FILES\The Program Directory\TheSecurity.mdw" "C:\PROGRAM FILES\The Program Directory\TheFrontEnd.mdb"

Note:
You may be able to start and modify the frontend just using the security file, but I would suggest converting FrontEnd to Same Security:
1) Start Access using the security file.
2) Create a blank, new database (FrontEnd)
3) Import all the Code, forms, queries etc.. from your app
4) Delete all linked tables and relink.
5) Compile all code in the Frontend

Now, Just use the security file to start your FrontEnd and it should work.

Good Luck,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121