admin permissions

  • Thread starter Thread starter Grant
  • Start date Start date
G

Grant

I've just used the Security Wizard to set up some security, but now can not
edit my database.
The DB opens without prompting for a password. I set up the Users Group with
Open/Run (on DB, Forms, Reports, Macros) and Read/Design (on Tables,
Queries). But I cant get into Design mode, it says I dont have permission to
read the table.
However when I enter the 'User & Group Permissions' option, it says current
user is Admin (who is member of the Admins Group) - though it looks like the
Admins Group has no permissions.
I've tried creating a new DB & importing everything, but this doesnt import
my Forms.
How can I get round this ? Any ideas ?
 
And here's the answer ...
I need to use the 'Shortcut' (created with the Wizard) to open the DB. This
enables me to login as any user I set up with the Wizard.
If I open the DB without the Shortcut, I get generic 'User' privs, which I
had restricted.
 
Back
Top