Occasional ODBC Timeouts From Access 2000 When Writing Record
- From: "David D" <DavidD@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Thu, 28 Apr 2005 16:43:26 -0700
I just inherited a database that has an MDB client (front-end only) accessing
records on SQL Server 7.
There's only a few tables, but the primary table has about 300k records and
roughly 100-120 fields.. mostly yes/no fields, but quite a few memos and text
boxes.
When using the front-end Forms to move between records and pull queries,
everything is fine. It's a little sluggish, but it works. And most of the
time you can change data on a record and it will behave like it should.
However, after about 3-5 minutes of activity, the next time you try to
update a record it will timeout giving the ODBC timeout error, and not write
the record. If I hit OK, then esc (to undo changes), I can still navigate
around and pull up new data... just can't write.
When I exit the database and reopen, everything is fine again for another
3-5 minutes. Server load is quite low, plenty of RAM and HD space.
If any one has any thoughts, I'd appreciate it.
-David
.
- Prev by Date: ODBC catalog function call return error on sql server 2005
- Next by Date: Re: Successful connection with invalid UserId
- Previous by thread: ODBC catalog function call return error on sql server 2005
- Next by thread: Named Instance not Displaying --- Only Server Name
- Index(es):
Relevant Pages
|
Loading
