Corrupted MDW file

[Guest]

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

 

[Joan Wild]

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.

 

[Guest]

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

 

[Joan Wild]

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.

 

[TC]

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