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)

Try using Trim$ on both.  Variable length strings sometimes don't get
passed correctly in
subroutine calls.

Ed
--
Edward C. Otto III

"If I had any decent opinoins, I sure wouldn't share them HERE!"
"May the Santa Claus of Life get stuck in your chimney, burn his suit, and
sue for loss of spousal consortium..."

Quote:> 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)