I have just taken on support of a split Access 2003 database. An immediate problem with it is that the back-end grows disproportionally.
There are 14 tables with about 37000 rows in total. The columns are numbers or text, there are no memo fields or stored images. There are no temporary tables or imports. Currently there are 16 users who perform data-entry tasks.
Yesterday the database grew to 140mb and users were being locked out. After compact and repair it reduced to 4mb.
Has anybody encountered this problem? And how can it be resolved?
Any suggestions would be appreciated.
There are 14 tables with about 37000 rows in total. The columns are numbers or text, there are no memo fields or stored images. There are no temporary tables or imports. Currently there are 16 users who perform data-entry tasks.
Yesterday the database grew to 140mb and users were being locked out. After compact and repair it reduced to 4mb.
Has anybody encountered this problem? And how can it be resolved?
Any suggestions would be appreciated.