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