Re: Can't run dynamic crosstab queries after setting up security

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

For your exclusive access message, is your database split?

Joan Wild
Access MVP

LAlayon wrote:
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
.

Relevant Pages

  • Cant run dynamic crosstab queries after setting up security
    ... as well as MS Access Security FAQs article. ... After I set up my "employee" group for my standard users who are only allow ... Have your system administrator to establish the appropiate permissions" Any ... exclusive access to the database at this time. ...
    (microsoft.public.access.security)
  • Re: Dbase locking others out
    ... > Folder the database is stored in. ... > Delete permissions on that folder. ... >> get exclusive access to the database. ... >> user get into one of the forms, it locks everyone else out of the ...
    (microsoft.public.access.security)
  • Re: How to secure a split db?
    ... permissions, how do I open the BE for exclusive access? ... If I understood TC's post correctly, after securing the database, all files ...
    (microsoft.public.access.security)
  • Re: List Users Permissions down to table.column action
    ... THIS STORED PROCEDURE GENERATES COMMANDS ... -- FIXED PROBLEMS WITH STATEMENT LEVEL PERMISSIONS GRANTING. ... -- CREATE TABLE TO HOLD LIST OF USERS IN CURRENT DATABASE ... -- GRANT USER ACCESS TO SERVER ROLES ...
    (microsoft.public.sqlserver.security)
  • Re: User access on a company intranet
    ... Yes they need full permissions on the folder where the backend is. ... You wouldn't need to do this in your copy of the database. ... However you can toggle the shiftkey bypass from another mdb file. ... When you want to implement security, you create a new mdw file, ...
    (microsoft.public.access.security)