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.

"Grant" wrote:

> 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 ?
>