I have about 40 users on a network, i have written a front end in visual basic which is then on all the users pc's. Then the database file is in a sharable directory in the server. I am using dao and Access97.
my database is about 50 megs with 4 tables my one table has 240 000 records. now it is getting corrupted intermitantly
can anyone shed some light here or something i can try
do i have to many users accessing the database file at once ?