|
Thread: DAO
-
Jan 8th, 2001, 08:18 AM
#1
Thread Starter
New Member
Here is my problem. using vb6sp4 and dao i referenced the system.mdw file that is not secure(meaning the admin does not yet have a password) and got the total number of users and groups and such. That works fine. But after the mdw file is secure, i try reading it again to get the users and i get the error message 'No read permissions on MSysAccounts'. I am like okay, so I open up the mdw file in access and give the admin administrator rights on every table and query in the mdw file. And I still get the error when I try to read it. Can anyone help me?
Here is some of the code i use
/////////////////////////////////////////
' Set the security file we are using
DBEngine.SystemDB = "c:\windows\system\system.mdw"
' Load the workspace by logging them in
Set uwkSpace = DBEngine.CreateWorkspace("", oUserName, oPassword, dbUseJet)
' Load the database into the workspace
Set uDatabase = uwkSpace.OpenDatabase("C:\mydatabase.mdb", False, False)
If uwkSpace.Users.Count <> 0 Then <---I get error here
End if
/////////////////////////////////////////
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|