Access 2000 bloating on data entry

N

NeedHelp

I have a database with parent-child tables where users enter text and numeric
information in a form. The form source is a query linking the parent-child
tables.
Upon entering 40 records in the parent table and 41 records in the child
table, the database bloated from an original size of 6.0 MB to 2.0 GB.
 
D

Destin Richter

Try running your "Compact & Repair" utility. Do you have any image files
being stored in the database?

Destin Richter
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2013: Form problem in reading data tables; relationship one-to-one 0
Access not enforcing referential integrity!!! 12
Using a subform to go to a record on the parent form 2
Dsum with multiple Criteria not working 0
One-to-One Table keys 9
Unbound Data Entry Form 5
Child table/subform 5
Including records with null values in report 8

Top