ODBC Timeout on Forms

M

Matt Kisasonak

I have form one with a recordset covering two tables.
The Recordset type = Snapshot and Record Locks = No
Locks. I open form two to edit the data that is in one
of the tables encompassed by table one. Table one is
left open. Form two's recordset contains only that one
table. It's recordset type is Dynaset and it's record
locks is Edited Records and allow edits is Yes. On about
every third change made through these forms it hangs and
gives me a ODBC timeout message. I don't understand
why! I don't get this message if form one is closed at
the time of the update. The error actually accurs when
form two runs Me.Requery. Can anybody help? Could it be
something on the server side?

Thanks

Matt

WindowsXP, OfficeXP Sp3
 
A

Arvin Meyer

Often, this is a network problem. While it could be the server, it may also
be due to collisions in the system. Have your network admin run a perfmon
check on the key network objects. Have him also check for CRC errors to see
if packets are dropping.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access Downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Top