Michael
Jun 22nd, 1999, 05:17 PM
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).]
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).]