logging a secured databse from another database via ADMIN user

G

Guest

Hello,
I need to log a secured databse from another totally unsecured database.
I think I have to go with the ADMIN user, which is the only one available in
my unsecured databse. But this wont work since in the secured database the
ADIMN user will have a password.
So I need to log via code (ADOX?) providing the password for the ADMIN user
in the secured database and then dealing with its objects and data in the
range of the ADMIN permissions.
Are all these thoughts right?
Thanks,
Rocco
 
J

jacksonmacd

Every Access session is run under exactly ONE identity. Therefore, if
you start your unsecured session as "admin", then you will be
identified as "admin" for the remainder of the session.

You could simply open your unsecured database when logged into Access
as a user on your secured Workgroup file. The unsecured database
wouldn't care, and the session would be properly identified to the
secured database.

Doing this would simply require the creation of a desktop shortcut
that logs onto the secured workgroup. See the website in my signature
for additional information.

The alternative it to start Access using the unsecured workgroup, and
then programmatically create a secured Workspace using DAO and VBA.
Then open a recordset and use it programmatically. You would not be
able to simply link to the tables. If this description sounds like
pure jargon to you, it's probably beyond your current skill level, and
you should use the first method.


Hello,
I need to log a secured databse from another totally unsecured database.
I think I have to go with the ADMIN user, which is the only one available in
my unsecured databse. But this wont work since in the secured database the
ADIMN user will have a password.
So I need to log via code (ADOX?) providing the password for the ADMIN user
in the secured database and then dealing with its objects and data in the
range of the ADMIN permissions.
Are all these thoughts right?
Thanks,
Rocco

**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top