Software

Ask something
Discussion Locked

Access Database mysteriously disappears

0 helpful
7 replies

by cbacon

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have designed an Access DB, that is used by 3 employees. It is stored in a folder on the NT server. Periodically after they have worked on it and closed out of the program, and try to open it again at a later time, it is gone. I have searched their PC and the whole server and it is nowhere to be found. This has caused us much time in having to restore from backup and reentering data. Does anyone have any idea as to what is causing this and how to prevent it.

7 replies

by don christner

Is the harddrive on the NT server set up as FAT or NTFS. Make it NTFS if it isn't already and then you can set the permissions to make sure that nobody can delete the file. You can also enable auditing to see who does what to the file.

Does anyone hold a grudge against the move to an Access database or against you? Sounds very suspicious.

Don

by brian.jones

As with the other answer - it seems that someone has a grudge against you or is doing something inadvertantly!!!

Just one point to consider ---- If you are using modules in the database it could be a case that you have an error in oneof them that is telling the database to delete it's self!!!

The other option is that you have a virus on the system that is deleting files altered by defined users - Have you got a good anti-virus on all clients as well as the servers.

Hope this helps and good luck

Brian J

by jlwolf

Occasionally some of our applications had been lost through users attempting to create their own shortcuts. An inadvertant "move" to the client desktop followed by a delete when the user discovers they don't have exactly what they wanted. Sometimes this drag and drop is a real drag.

This discussion is closed to new replies.