Maximum Records In A Database

kevsim

Registered User.
Local time
Tomorrow, 03:22
Joined
Aug 10, 2002
Messages
34
I have a database written in Access 2000, then converted to Access 97 so others can access. All data input was working OK from all users, until I reached record 7690. The record selector is then Grayed out, if I delete one record, all is OK until I reach record 7690. The database file is 1650KB. The database is set for "Compress on close". I would appreciate some advise as to what the problem may be.
kevsim
 
97 doesn't have a compact on close option, have you tried importing everything into a new blank db?
 
Rich, I thank you for your input in attempting to solve my problem. The answer to the problem – There was no problem. It was my own fault believing other people and not checking for myself. It turned out the server they were using was at fault and not Access.
kevsim
 

Users who are viewing this thread

Back
Top Bottom