
Manipulating a secure Access2 db in VB4(16)
I hope someone can answer this for me. I have tried numerous variations
with no luck.
I have created a new security file and referenced that in an ini file
(db1a2.ini) as follows:
[Options]
SystemDB=C:\PROJECTS\SECURITY\Test.MDA
And in my procedure I have as follows:
DBEngine.IniPath = app.path & "\db1a2.ini"
MyUserName = "Admin"
Set MyWorkspace = DBEngine.CreateWorkspace("", MyUserName , "password")
If I join Test.mda and Logon as Admin using "password" in Access2, it
works, but no go in VB4.
I have tried the following in VB4 to access a Access95 db with success.
Dim Password as string
Set dB = DBEngine.Workspaces(0).OpenDatabase(App.Path & _
"\" & dBName,False, False, ";PWD=" & Password)
(can you please adv what the False,False parameters refer to?)
Any suggestions????
Thanks in advance.
Peter