cant open database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

IM sure you get this all the time but...

yesterday i was working on another PC where i went throug the steps to setup
User Level security, it seemed to work, though i didnt check it for other
users, i was prompted for my password everytime i opened the database on that
computer. I even printed out the one step security wizard Report (which is
where i get most of my information).

This morning i am on a different comptuer but as the database is on the
network im assuming that i can open it and put in my password, i cant!!
Instead i get the following message:

You do not have the necessary permissions to use the
'H:\Data\Access\test1.mdb' object. Have your system administrator or the
person who created this object establish the appropriate permissions for you'

and when i click ok i get a blank screen, Thanksfully thats the backup so iv
still got all my information but how can i open it??
I am the administrator!!

It is telling me that the Workgroup information file is at
H:\Data\access\Security.mdw

I think i need to point the access to this file on each computer so that it
knows where the user information is kept, how might i do this or what else do
i need to do??

With much thanks,

Amit
 
Ok sorry guys i just figured it out!!! use the workgroup administrator to
point to the workgroup info file and its all working now!
 
DowningDevelopments said:
Ok sorry guys i just figured it out!!! use the workgroup
administrator to point to the workgroup info file and its all working
now!

A better option is to keep the standard system.mdw workgroup as the default.
Instead create a desktop shortcut to launch your secure mdb. That way they
won't be prompted for a login for *all* databases. The target would look
like
"path to msaccess.exe" "path to mdb" /wrkgrp "path to mdw"
 
Back
Top