Kamis, 02 Mei 2013

[MS_AccessPros] BE bloat

 

Problem: Database bloat
Split Setup: Access 2003 BE on a server and
2007 FE on each user's local drive. The FE is an mde file.

One of the BE's frequently (once a week) bloats from 1.5 meg to 15 - 20 meg overnight.
Compact and repair immediately brings the BE back to 1.5 meg.

The FE does not create any temporary files. There are no pictures stored in the BE.

The FE is pretty basic - forms to determine what is available and the ability to write / modify a few production records. There is not a lot of activity in this database! I've ensured the I close objects (rst.close, db.close, set rst nothing, set db nothing)

1) Does anyone have any ideas what I can do to find out why this BE is bloated.

There are at least another dozen FE databases similar to this one (not linked to the BE above) that are not creating a bloat problem.

Thanks,
Patty


__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (1)
Recent Activity:
MARKETPLACE


.

__,_._,___

Tidak ada komentar:

Posting Komentar