Very Computer

If I have a valid Access user id & password (confirmed by running access)
why would I get a runtime error 3029  "Not a valid account name or
password"  while creating a workspace as in the following code.
=============================
' User and Pswd are set in earlier code (have also tried hardcoding)
' Note:  Set the inipath or will error with SYSTEM.MDA not available
DBEngine.IniPath = "C:\Windows\MSACC20.ini"
Set wsStock = DBEngine.CreateWorkspace("", User, Pswd)

Comment out the createworkspace and the following non-secured code does
work
===============================
Set dbStock = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\stock.mdb")
======

I'm Using Win95 OS,  VB4-16bit with Access 2.0  (enduser is in win3.1)

This could be caused by the DBEngine already being initialized.  Try adding
the following line before any reference to the DBEngine:

Set DBEngine = Nothing

Nope,
That didn't work.

Quote:> This could be caused by the DBEngine already being initialized.  Try
adding
> the following line before any reference to the DBEngine:

> Set DBEngine = Nothing

If I have a valid Access user id & password (confirmed by running access)
why would I get a runtime error 3029  "Not a valid account name or
password"  while creating a workspace as in the following code.
=============================
' User and Pswd are set in earlier code (have also tried hardcoding)
' Note:  Set the inipath or will error with SYSTEM.MDA not available
DBEngine.IniPath = "C:\Windows\MSACC20.ini"
Set wsStock = DBEngine.CreateWorkspace("", User, Pswd)

Comment out the createworkspace and the following non-secured code does
work
===============================
Set dbStock = DBEngine.Workspaces(0).OpenDatabase(App.Path & "\stock.mdb")
======

I'm Using Win95 OS,  VB4-16bit with Access 2.0  (enduser is in win3.1)