Opening a secured file

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

Guest

I have worked through the "secure and access db with user-level security" instructions, but when I then try to open my database I get a message saying that I do not have the necessary permissions - but I do not get a log in dialogue to let me sign in.

I am adapting an exisiting secure db and I have seen that they have a shortcut set up - is this the only way of opening a secured database?

(I am developing on a stand alone but will be installing on a shared WAN drive - using Access 2002)

Thanks

Helen
 
HelenJ said:
I have worked through the "secure and access db with user-level
security" instructions, but when I then try to open my database I get
a message saying that I do not have the necessary permissions - but
I do not get a log in dialogue to let me sign in.
Click to expand...

Then you are trying to open it using a workgroup where the users/groups do
not have permission in the database. Since you don't get the log in dialog,
you are likely trying to open it using the standard system.mdw that ships
with Access. Every session uses this unless you specify otherwise. It is
logging you in silently as the Admin user. Rightfully so, you can't open
the secure database.
I am adapting an exisiting secure db and I have seen that they have a
shortcut set up - is this the only way of opening a secured database?
Click to expand...

That's the usual way. Alternatively, you can open Access 2002 (no database)
and go to Tools, Security, Workgroup Administrator, and change your default
workgroup from system.mdw to the secure mdw you want. However that will
change it for every session of Access, which usually isn't desired. Once
you have it in production, remember that you'd have to change the default on
all workstations, and some people may have unsecured databases they wish to
run. The desktop shortcut makes it easier, as the workgroup specified only
applies for that session of Access.
(I am developing on a stand alone but will be installing on a shared
WAN drive - using Access 2002)
Click to expand...

Sharing directly over a WAN is a recipe for disaster. Consider replication
or Terminal Services instead. Read
http://www.attcanada.net/~kallal.msn/Wan/Wans.html
 
Thanks Joan,

After posting my question I discovered that Access had
been putting shortcuts on my desktop (it's a shame there
is no mention of this in the help)

I also read the article about WAN's - I am actually
replacing an exisiting database and the remote users will
essentially only have read access - but an interesting
point - I will sound out the network manager!

Helen
 
Back
Top