Passing user and pwd to instance of Access

[jojones]

I have the following in VB...

Public Sub Main()
Dim myAccess As Access.Application

Set myAccess = New Access.Application
myAccess.OpenCurrentDatabase ("C:\Test.mdb&quot
myAccess.Run "myProcedure"
myAccess.Quit
Set myAccess = Nothing

End Sub

It work just fine, however we have an Access MDW workgroup setup on our network and when Access is instantiated it prompts for the user and password. In a batch file I would use:
/user "username" /pwd "password"

How can I get past this with code?

Thanks in advance.

 

[zakman]

Take a look at this page... it might help...

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q235422

good luck!

 

[jojones]

This doesn't work. It still prompts me for the username because it is a workgroup username & pwd rather than a db username & pwd.

Any more ideas?

Thanks
Jo