| David D 2005-04-28, 8:23 pm |
| 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
|