Cant add new users ! please assist!

  • Thread starter Thread starter 2vao
  • Start date Start date
2

2vao

Hello,

I have been working on my db as a member of Admins , I just realised that I
cant add any other user at all -
I get a message:
You do not have the necessary permissions to use the 'C:\Documents and
Settings\...\mydb.mdb' object. Have your system administrator or the person
who created this object (myself on my pc) establish the appropriate
permissions for you.

Do I need to create a new workgroup ? How do I go about it to avoid myself
being locked out of my own db ?

Sometime ago, I was trying to create a new workgroup and somehow locked out
of all my access db. I used this C:\Documents and Settings\User\Application
Data\Microsoft\Access\System.mdw to enable me access my dbs and since then I
did not try to add users or mess around with workgroup security.


Many thanks.
 
Go into Workgroup Administrator and join the System.mdw workgroup. If you
need to join a secure workgroup, do so for a specific Access session by way
of a shortcut:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"
"\\ShareName\FolderName\YourDB.mdb"
"/wrkgrp \\ShareName\FolderName\Security.mdw"

There are links to further information here:
http://www.geocities.com/jacksonmacd/
I have found Jack MacDonald's paper to be thorough and clear, but the others
are well worth reading. In particular, the Security FAQ contains a lot of
information, although it has not been updated for some years, so there is
still stuff in there about security with Access 2.0 and things like that.
 
Thank you Bruce, it works, I was really scared because of my past experience,
thank you for the links and tips. I really appreciate it/
 
Glad to help. User-level security is a bewildering business at first (and
for a while after that).
 
Back
Top