Opening Access in VB

[Michael]

It looks like I may have baffled all you VB-ers out there because this is my second posting of this problem, having had no replies to my first posting!!!

I am trying to open an instance of Access within VB6. The db is secured.

I am using this code:

Dim wsAcc As WorkSpace
Dim accApp As Access.Application
Set wsAcc = CreateWorkspace("TempWS", strCurrentUser, strCurrentPassword, dbUseJet)
Set accApp = New Access.Application

(strCurrentUser and strCurrentPassword are a valid user name and password)

When executing the line
Set accApp = New Access.Application
I am prompted for the password, although the correct username is displayed in the Access login box.

Why is it not accepting the password that I have set up for the workspace? I am trying to get Access loaded "invisibly".

I am using VB6, Access 97, and Jet/DAO.

Thanks in advance.


[This message has been edited by Michael (edited 06-28-1999).]

[Michael]

(Dummy reply to get date updated!)

[This message has been edited by Michael (edited 06-28-1999).]