Access 2000 bloating on data entry

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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 not enforcing referential integrity!!! 11
Using a subform to go to a record on the parent form 2
Child table/subform 5
Linked Child Record Losing Parent ID 2
Unbound Data Entry Form 5
Deleting duplicate parents and grouping children to single parent 3
Can I auto resize a subform in continuous mode 0
form/subform-require at least 1 new subform record at data entry 1

Back
Top