hi

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.

code

Private Sub Command154_Click()

Dim appAccess As New Access.Application
appAccess.OpenCurrentDatabase ("C:\main\storage\calc\calc.mdb")
appAccess.Run "calc.calcupdate"



End Sub


it is running fine, just want to eliminate the password entry.

Hello,

see if this helps:

http://support.microsoft.com/kb/209953

Martin

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.

Thanks again

Hello,

I never needed to run code from an ULS database via automation, but I think the way leads via:

appAccess.DBEngine.SystemDB

property and

appAccess.DBEngine.CreateWorkspace

method.


Once you have created the new workspace, you may use

appAccess.OpenDatabase

method, and finally

appAccess.Run

Please see Access help for syntax.

Martin