Jul 21 2008, 10:51 PM
i have a code in access that is calling a code in another database, however i have protected ms access with the workgroup password, and the system prompt for a user name and password each time this code is running, and i need a way of capturing the user name and password, and then sending it via the code, so user will not be prompt each time for the password again and again.
Private Sub Command154_Click()
Dim appAccess As New Access.Application
it is running fine, just want to eliminate the password entry.
Jul 22 2008, 12:20 AM
Jul 24 2008, 12:11 PM
thanks for your help, however, thats for database password, i need something fo rthe Microsoft Access user-level security feature, which microsoft however point out there, that the article does not apply to this feature.
So I need help with this issue, i you or anyone can do so i appriciate it.
Jul 24 2008, 01:55 PM
I never needed to run code from an ULS database via automation, but I think the way leads via:
Once you have created the new workspace, you may use
method, and finally
Please see Access help for syntax.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here