MDW File changes not updating on network

From: Barbara (barbara_florio_at_urscorp.com)
Date: 08/20/04 

Date: Fri, 20 Aug 2004 09:46:41 -0700

I have an access .mdw file that has been operating
smoothly for several months now. Just the other day once a
new copy of the front end database was uploaded to the
network, suddenly I started experiencing user's having
problems making changes to their data. I went in the
security file on the network through my computer and
noticed that their "Update" and "Insert" rights for the
queried behind these forms had been stripped away. So I
added them back in to the mdw. Still no luck. It wouldn't
update for the user until I went to the user's machine and
manually made the update to the security file from their
machine that the changes would take for the user and be
seen within the workgroup file from the user's machine.
Why is this? The users are all mapped to the Security file
that is located on the network. They access the security
file when they start up a shortcut on their desktop.

Any idea what could be wrong? It's always the same 8
queries that lose their permissions. And it's only these
two groups of people that are having the problems.

Relevant Pages

  • MDW File changes not updating on network
    ... tables and queries are located in the database itself, ... make the change in the security file. ... >I have an access .mdw file that has been operating ... >queries that lose their permissions. ...
    (microsoft.public.access.security)
  • Auto Signon and Joining MDW Group
    ... Client-Server architecture where the data exists on a network share ... local the MDW file on the network share and Join. ... User's table, each time the user logs into the database, they are prompted to ... users enter the same default admin password combo. ...
    (microsoft.public.access.security)
  • Re: Admin/owner of the db is receiving permission message
    ... Access security on a network located database. ... You can specify the network location for the mdw file using either a mapped drive or the UNC pathname ...
    (microsoft.public.access.security)
  • Re: Getting started with security
    ... we discovered that corruption of the security file was a common situation ... degree of corruption to a .mdw file when it was housed on a single server. ... My previous company had hundreds of databases linked to the same .mdw file ...
    (microsoft.public.access.security)
  • Re: Using NTRIGHTS utility in Windows 2000
    ... Slaving his hard drive should work. ... You say you can not access his C$ share over the network. ... user/password that is an administrator on the locked out computer and in the ... or trying Recovery Console to copy the security file ...
    (microsoft.public.win2000.security)