Allowing Multiple users to open the front end

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



So if I am understanding everything correctly the only way to allow multiple
users to open a "Microsoft Access 2007 Front End" is to allow all users full
permissions (read/write/modify), and if I want to limit certain users'
permissions I must convert the database from .accdb to .mdb and loose the
features of the database that are only available in 2007?

Is there any other way? I would like multiple users to be able to open the
Front End of the database while some users have full permissions and some
users have read only permissions and still maintain all the features of
Microsoft Access 2007.
.



Relevant Pages

  • Re: Linking to a database which is in use
    ... This is probably a permissions problem on the directory in which the backend is ... See ACC: Determining Which User Has Opened Database Exclusively ... Tony Toews, Microsoft Access MVP ...
    (comp.databases.ms-access)
  • Re: can not open MDB file
    ... > To remove User-Level security on your Microsoft Access ... > that defines security for the database that is secured. ... Grant full permissions to the Users group and the Admin user account ...
    (microsoft.public.access.security)
  • Re: Beginning C# Q
    ... What is a typical method for handling multiple ... when the user submits changes to the database that the users ... > Groups table, which defines which Groups users belong to, and a Permissions ... That is why an Interface is called an Interface. ...
    (microsoft.public.dotnet.framework)
  • Re: Front End Opens Backend Exclusive
    ... database in the morning and the backend is being opened exclusively by ... save and delete a notepad file. ... I strongly suspect their permissions are inadequate. ... Tony Toews, Microsoft Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: import security definitions
    ... Microsoft Access MVP ... can not select a table to copy the permissions to.. ... DB1 is owned by Administrator (I have to take the permissions of this ... to copy the permissions from the old database to the new database. ...
    (microsoft.public.access.security)