Help : Accessing a secure access 2.0 database from VB4.0
Quote:
> Hi netters,
> I am trying to use DAO from Vb4.0 to access a Access 2.0
> database. I added a user to the jet users using the users menu in Access
> 2.0. I wanted to secure the database too. So I changed the password of
> the admin account from blank string to something. In VB, from my login
> procedure, I am trying to create a secure workspace as the first thing
> before any other data access using the CreateWorkspace method. When the
> admin password wasn't changed, I was able to create the workspace with
> admin as well as the new user (say xyz), but as soon as I changed the
> password of the admin user, I am not able to create the workspace either
> with "Admin" or "xyz". Is the solution I am using (creting a secure
> workspace) pretty much the standard way of accessing a secure database.
> If it is, what I am doing wrong? If not, is there a better approach?
> BTW, I created a new system.mda file and the above password scheme works
> from Access 2.0 gui. Thanks a lot for any help..
> - Sameer
Have you set the SystemDB in VB? Depending on your version there are
different ways to set it.
Search on SystemDB in the help files and it will show you how. This
must be done before you create your workspace.
Frank
OA Comp Inc.
