Intermittent errors on multi-user system

I work on a multi-user system which has been in production use at
several sites for years. The database MDB lives on a server, and the
MDE file is run from each user's workstation with tables linked to the
database MDB on the server.

One (and only one) of the sites has recently started experiencing
intermittent database errors. It happens completely randomly (to all
appearances, anyway) - not related to any specific user, nor to the
number of users on at once, nor to a specific line of code, nor to the
amount of network traffic.

The errors received are quite standard and familiar to all/most of us:
- Unrecognized database format
- You do not have the necessary permissions to use...

The users have been hitting enter to clear the error message and then
proceeding - with the database being fine after the error with no
intervention (ie. to clear locks or repair the db).

This has not only me stymied, but also the tecchie-guru-god-guy that I
work with. Any suggestions or comments or advice would be HUGELY
appreciated.

wrote in message

> I work on a multi-user system which has been in production use at
> several sites for years. The database MDB lives on a server, and the
> MDE file is run from each user's workstation with tables linked to the
> database MDB on the server.
>
> One (and only one) of the sites has recently started experiencing
> intermittent database errors. It happens completely randomly (to all
> appearances, anyway) - not related to any specific user, nor to the
> number of users on at once, nor to a specific line of code, nor to the
> amount of network traffic.
>
> The errors received are quite standard and familiar to all/most of us:
> - Unrecognized database format
> - You do not have the necessary permissions to use...
>
> The users have been hitting enter to clear the error message and then
> proceeding - with the database being fine after the error with no
> intervention (ie. to clear locks or repair the db).
>
> This has not only me stymied, but also the tecchie-guru-god-guy that I
> work with. Any suggestions or comments or advice would be HUGELY
> appreciated.

I hate intermittent errors. One would always prefer a good old fashion
system crashing GPF. They are easier to find and repair. <g>

All these errors sound like a problem with the "wire". Duh. <g> One has to
have full permissions on the mdb folder. Apparently Jet/Provider/Driver (ado
or dao) are losing it. The problem is trying to locate it by long distance.
One factor in your favor is it appears to be a "site" problem. Can you put
someone on-site? I bet a little investigation of the local net/lan and you
will be able to isolate the problem.

You might find something here. Always worth a read if you haven't yet. <g>
http://support.microsoft.com/kb/303528/

hth
-ralph