Database Bloating

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

C Corvec - 17 Jul 2006 04:34 GMT

I have a multi user database that goes exponetially when it is use. It is a
split database. Each user has their own deont end. However you can literally
'watch' it grow when I have twelve users in it at the same time

Reply to this Message

Larry Linson - 17 Jul 2006 06:26 GMT

> I have a multi user database that
> goes exponetially when it is use. It is a
> split database. Each user has their
> own deont end. However you can
> literally 'watch' it grow when I have
> twelve users in it at the same time

Are there lots of updates and deletes? Are you storing images in OLE
Fields? Does Compact and Repair take it down dramatically? Which is
growing, the user's front-end or the common back-end? Are you creating and
deleting temporary tables, or are you using a Delete Query to clear a
permanent table frequently?

Larry Linson
Microsoft Access MVP

Reply to this Message