Hello,
I've been searching all over the net, as well as Microsoft's Knowledge Base, but could not find what I need. Basically, I'd like to take an Access 2000 database, secure it using the following:
(1) "Database Password"
(2) Access User-Level Security
Then, I would like to open them up, having the user login, but automatically bypass the "Database Password".
I can bypass the "Database Password" by opening the file through ANOTHER file. The user would open a different file which uses the OpenDatabase method to open the main database file, along with the "Database Password", but I can't utilize the "Secured.MDW" workgroup file to instate user-level security.
On the other side, I can create a shortcut which refers to the "Secured.MDW" file and have the user login. However, they have to deal with the "Database Password", which I can't seem to bypass with VBA code at this level.
Can someone please help? To reiterate, my objective is to use access level security, in a "Secured.MDW" file, via the "/WRKGRP" switch. ALSO, I want to bypass the "Database Password" if they go through the shortcut (user-login). If the user opens the Access database directly, it will prompt them for the "Database Password".
Any ideas?
Thanks!!
Jung
I've been searching all over the net, as well as Microsoft's Knowledge Base, but could not find what I need. Basically, I'd like to take an Access 2000 database, secure it using the following:
(1) "Database Password"
(2) Access User-Level Security
Then, I would like to open them up, having the user login, but automatically bypass the "Database Password".
I can bypass the "Database Password" by opening the file through ANOTHER file. The user would open a different file which uses the OpenDatabase method to open the main database file, along with the "Database Password", but I can't utilize the "Secured.MDW" workgroup file to instate user-level security.
On the other side, I can create a shortcut which refers to the "Secured.MDW" file and have the user login. However, they have to deal with the "Database Password", which I can't seem to bypass with VBA code at this level.
Can someone please help? To reiterate, my objective is to use access level security, in a "Secured.MDW" file, via the "/WRKGRP" switch. ALSO, I want to bypass the "Database Password" if they go through the shortcut (user-login). If the user opens the Access database directly, it will prompt them for the "Database Password".
Any ideas?
Thanks!!
Jung