Hello,
Can a database get too big? The one I've developed for
my office keeps dropping information. six main tables and
20 or so queries.
The table contain 120 to 4500 records.
Any ideas or comments would be appreciated.
That's TINY. 10,000,000 records is "too big", though I know of
databases twice that size!
If you have not done so already, use Tools... Database Utilities...
Compact and Repair Database. It's good routine maintenance. The limit
on the size of a database is 2 GByte; there is no explicit limit on
the number of records in a table.
In my experience, most if not all cases of data being unexpectedly
deleted from tables is because a PEBKAC - "Problem Exists Between
Keyboard And Chair". Some users may incorrectly assume that they can
delete data from a Query (because they don't want it included in a
report, perhaps), not realizing that a query is just a view of data in
the table, and that deleting the record from the query deletes it from
the table. Or they may be unintentionally deleting a record from a
Form (with the same effect). Do your users have access to table or
query datasheets? If (better) they can only interact with the data
through Forms, you may want to consider putting VBA code in the Form's
BeforeDeleteConfirm event to prevent deletion of records, or at least
make the user aware of the consequences.
