I have a rather odd problem that I'm at a loss to explain.

The mdb is in A2K2 format, and has many tables linked to around 3-4
different back end mdbs. It is running on a Win2K3 server (set up as a TS
application server, if that's relevant).

The process that is running is producing a large number of reports,
sometimes to .snp format, sometimes to printer. When trying to access one
particular mdb, it will come up with the error "<mdb file> in use" or "Too
many active users". This latter one has only come up recently.

The odd thing is that the only thing it is trying to do at this point is a
DCount. When the error message occurs, I can resume code execution and it
runs properly. I *could* error trap that message and resume, but I would
rather get to the bottom of this.

The error is intermittent. When I run the test without other users using the
same data, the error does not occur. The front end is not shared.

Any ideas would be appreciated.