Re: Front End Opens Backend Exclusive

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

On Oct 9, 6:11 pm, "Tony Toews [MVP]" <tto...@xxxxxxxxxxxxxxx> wrote:
Armageddon <Matt.W.Steph...@xxxxxxxxx> wrote:
I have a multi user database with an MDB on a network shared drive.
And each user has a local copy of the frontend MDE. This database was
created in Access 2000. Recently some users were upgraded to Access
2003. One particular user is always the first one to access the
database in the morning and the backend is being opened exclusively by
this user through the front end.
I have done several test on the users machine.
* The default open method is set to shared.
* The permissions are ok in the network shared drive. I am able to
create, save and delete a notepad file in the same directory as the
back end from their machine.

You can create, save and delete a notepad file. But can that one
particular user? I strongly suspect their permissions are inadequate.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems athttp://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog -http://msmvps.com/blogs/access/

Yes that user can. I was at their station under their logon when I did
the notepad test.

.

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: 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)
  • 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)