Identify cause of reserved error -1104 in Access

[Pingwin101]

We are running numerous Access databases on a network serving approximately 400 users. At any given time, there are 2-5 users in a database simultaneously. Most of these Access databases link to SQL Server tables using ODBC.

Some users are getting a "reserved error -1104". They get this message sporadically, and not every user gets this message. Most times, if they exit the database and get back in there is no problem and no further messages.

The Network Administrator checks the network and file servers and there is no evidence of a network issue. We HAVE found that when one person gets the message another person in another building on another floor will often get it around the same time.

We have compacted and repaired databases regularly. We are monitoring SQL Server and Network activity and there is no consistency to indicate what is generating this message. Does anyone have any idea what this is and/or what solution there might be?

 

[BigRed1212]

This post:

http://www.jsw4.net/info/listserv_archives/mysql/03-wk42/msg00001.html

seesm to suggest changing ODBC drivers. Most of the other stuff on Google suggests it is pretty elusive and pretty random.

 

[PHV]

there are 2-5 users in a database simultaneously
In a Front End ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Pingwin101]

Thanks so much for your feedback. We are finding the same answers (or lack thereof): not much information available.

As for the users--yes, in a front end. We see some degradation in speed on occasion, but this reserved error is new (within the past few months). Prior to that the organization has been using Access for over a decade fairly successfully--even with multiple users!