We are running an MS Access 2000 backend, 6mb file, not huge, on a network share. The front end is copied to the users desktops with a batchfile whenever there are changes to the front end.
I'm thinking the problem lie in the fact that at any given time we have over 300 users (maybe as many as 400) pushing data to the backend tables, which for the most part, are Access tables.
I read a thread (hey, that rhymes) about the max number of connections, however, we've had over 200 users on this db for a couple years. Just recently, the users desktops were migrated to XP SP2, but I can't be certain that is the problem. Also, we're not running the backend on a desktop, rather, in a shared location on a server, so I don't think that is the issue.
Any assistance is appreciated. And articles to show solutions, also appreciated.
Regards.
Rich.