View Single Post
  #11 (permalink)  
Old May 23rd, 2011, 04:09 PM
HiTechCoach HiTechCoach is offline
Friend of Wrox
Points: 1,015, Level: 12
Points: 1,015, Level: 12 Points: 1,015, Level: 12 Points: 1,015, Level: 12
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 245
Thanks: 5
Thanked 24 Times in 23 Posts
Default

Curious, How big is the database?

After open lots of objects in design mode the database can bloat significantly. If it get to the 2 gig limit you will have all kinds of issues. It is common to have database corruption when this happens.

If the database if very large even after compacting then you will have to be very careful and watch the file size..
__________________
Boyd Trimmell aka HiTechCoach (.com)
Microsoft Access MVP Alumni 2010-2015
Reply With Quote