CreateWorkspace-from 1 db opening another

[dvh]

Hi guys,

I searched the whole day but couldn't figure out this. Any help is greatly appreciated!!
I got my code working fine in Excel, but just cant get it run in Access when i try to open a secured db with group security from a normal Access 2k db.

DBEngine.SystemDB = "C:\Documents and Settings\Desktop\system.mdw"
Set MyWorkspace = DBEngine.CreateWorkspace("New", "xx", "xx", dbUseJet)

Error 3029 encountered at "CreateWorkspace" line although correct password and user name supplied. DAO reference is also set.

Thanks a lot

 

[dvh]

hi
maybe i was too brief..
so here i try again..I want to open a secure backend database. And i got my code working fine in Excel (open the db, grab data). The problem is when i run in Access and it gives error 3029 at this line (password,username all correct)

Set MyWorkspace = DBEngine.CreateWorkspace("New", "default", "", dbUseJet)

So i guess my question is why the error and can i open another workspace in Access?
thank you

 

[dvh]

Phew..found the problem. The Access program open the default system workgroup instead using the workgroup i assigned

DBEngine.SystemDB = "C:\Documents and Settings\pete\Desktop\group.mdw"

 

[vbaInet]

Glad you got that sorted and thanks for posting back on your success.