Access 97 System.mdw gets corrupted frequently
Posted on 2001-08-31
I am using Access 97 as the back end and VB as the front end.
I am using User lever Security. Its a network app. Now the problem that i am facing is that the System.mdw gets corrupted within 2 hours after i have repaired it. I have around 5 to 6 users at peak times and normally its 2 or 3 users active at any one time. Then 1 user eg will logoff and another user will login using his username and password only to find they can't login.
Its a pain to tell the logged on users to logoff, so i can repair the System.mdw file and so the now that user can login (b/c the system file has been repaired).
I am using Win2K Pro, 64mb ram etc.
Any suggestions pls