I seem to be having a frequent problem with a corrupted MDW file. When it
happens, only limited users are able to log into the database (one to three
users). Today when the issue came up, only three users were able to get in,
but on previous occurances, it was one or two users. To fix the problem, I
compact and repair the system mdw file and it renames this file to db1.mdw.
I then must rename it to the original file name (after renaming the original
corrupted mdw file to). SOmething else kind of quirky that happens is that
when this the MDW file gets "corrupted" , the idb file (access lock file) for
the database will not close even though all users are out of the database. I
must restart the individual computers to "close" this file. I cannot even
delete the file. This procedure must be done before the mdw can be repaired.
My question is what is causing the mdw file to get corrupted and what can
done to help avoid this in the future? I have about 8 users on the system
accessing the database. the back end of the database is about 125mkb. Thanks

"Jeffery" <(E-Mail Removed)> wrote in message
news:CD8622CC-38A5-4ED3-A1CE-(E-Mail Removed)...
>I seem to be having a frequent problem with a corrupted MDW file. When it
> happens, only limited users are able to log into the database (one to
> three
> users). Today when the issue came up, only three users were able to get
> in,
> but on previous occurances, it was one or two users. To fix the problem,
> I
> compact and repair the system mdw file and it renames this file to
> db1.mdw.
> I then must rename it to the original file name (after renaming the
> original
> corrupted mdw file to).

Perhaps you don't have delete permissions on the folder where the mdw is
located. All users need delete permission on the folder.

> My question is what is causing the mdw file to get corrupted and what can
> done to help avoid this in the future? I have about 8 users on the system
> accessing the database. the back end of the database is about 125mkb.
> Thanks

The mdw when in use, also creates a ldb file. When the last user exits this
ldb should be deleted. Since they don't have delete permissions, it can't.


--
Joan Wild
Microsoft Access MVP

They do not have delete permissions. I will change that. Would this cause
the mdw to get corrupted?

"Joan Wild" wrote:

> "Jeffery" <(E-Mail Removed)> wrote in message
> news:CD8622CC-38A5-4ED3-A1CE-(E-Mail Removed)...
> >I seem to be having a frequent problem with a corrupted MDW file. When it
> > happens, only limited users are able to log into the database (one to
> > three
> > users). Today when the issue came up, only three users were able to get
> > in,
> > but on previous occurances, it was one or two users. To fix the problem,
> > I
> > compact and repair the system mdw file and it renames this file to
> > db1.mdw.
> > I then must rename it to the original file name (after renaming the
> > original
> > corrupted mdw file to).
>
> Perhaps you don't have delete permissions on the folder where the mdw is
> located. All users need delete permission on the folder.
>
> > My question is what is causing the mdw file to get corrupted and what can
> > done to help avoid this in the future? I have about 8 users on the system
> > accessing the database. the back end of the database is about 125mkb.
> > Thanks
>
> The mdw when in use, also creates a ldb file. When the last user exits this
> ldb should be deleted. Since they don't have delete permissions, it can't.
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
>
>

"Jeffery" <(E-Mail Removed)> wrote in message
news:0DDB86A4-C57E-4444-8203-(E-Mail Removed)...
> They do not have delete permissions. I will change that. Would this
> cause
> the mdw to get corrupted?


Possibly, since the ldb never gets deleted. (perhaps you're providing
evidence that it does). Post back with the results.

--
Joan Wild
Microsoft Access MVP

How do you know that the workgroup file is being "corrupted", and what
do you mean when you say that some users "can not get in to the
database"? What actual error message or other problem occurs?

TC