Can't run dynamic crosstab queries after setting up security

[LAlayon]

I set up security in Access 2003 through a new workgroup following Keith
Wilby's recommendations, as well as MS Access Security FAQs article.

After I set up my "employee" group for my standard users who are only allow
to enter basic data through an input form and run some reports, I can't get
some crosstab queries to work in a form that dynamically changes the crosstab
query definition based on the criteria entered by the user. I get a message
saying "You don't have the necessary permissions to use 'MSysTables' object.
Have your system administrator to establish the appropiate permissions" Any
ideas what type of permissions I need? I gave read/update/insert/delete
permissions to those queries to that group.

Last ... I am also getting a message everytime these standard users open the
database and the switchboard form comes up that tells them "You don't have
exclusive access to the database at this time. If your proceed to make
changes, you might not be able to save them." Is there anyway to get rid off
it? My standard users don't need to be making design changes.

Thanks,

Lisbet

 

[Joan Wild]

See
http://www.jmwild.com/MSysTables.htm

For your exclusive access message, is your database split?

Joan Wild
Access MVP