Hi, I'm running a multi-user Access 97 database on a network. I've placed all the files onto the network with user-level security. I have a front and back end. There's about 7 people with permission to write and about 10 people with read permission.
My problem is that my front end, which has everything except the tables, keeps crashing at least once a day. I run regular maitenance on it by compacting and sometimes decompiling and compiling. The file is only about 1.5 megs. It's a very simple database. Now, I've heard that there shouldn't be more than 10 people using it at the same time or I may run into may problems, but I only usualy have about 7 logged on at one time.
I'm getting errors like, unrecognizable database format, or "reserved error(-3034)", "Unexpected error (35012)", "Records can't be read; no read permission" (this one happens when i try to compact and I am logged on as the administrator). If anyone knows how to fix or prevent any of these problems, please let me know.
I'm wondering what are some possiblities of why my program would be crashing. Would it have anything to do with my code? Has anyone experienced problems when two or more people running different queries or appending to tables at the same time? Basically, I want to know how I can proof and test my program a little better.