Database size problem

[Les Blair]

I have a Database that was only 15mb I have not increased the number of records but I have increased some of the code. it now is up to 171mb and when I do a Compact and Repair it does nothing. Is there any other way to get it back to a reasonable size other that delete code.

 

[boblarson]

I have a Database that was only 15mb I have not increased the number of records but I have increased some of the code. it now is up to 171mb and when I do a Compact and Repair it does nothing. Is there any other way to get it back to a reasonable size other that delete code.

You can try creating a new, blank database and then import all of the objects in. Sometimes a db will just go wonky and importing into a new one is the only way to go.

 

[CraigDolphin]

How much code did you add and what does it do? It seems unlikely to me that just adding a few modules would add so much bulk to the file unless you created a whole lot of indices or other hidden/system tables. Or if you added some graphics to forms or somesuch. Makes me wonder if you might have caught a little M$ corruption.

You could try creating a new, blank db and importing all the objects from the original into the new and see if that removes some of the bloat.

 

[Les Blair]

Thanks, I will try that

 

[aikea]

Separate database into front end and back end

You may try to separate your database into a front end and back end.

Just create a new database, import all queries, reports, etc into the new database but only import links fromt he table. Delete all queries, reports, etc from the old database only leave the table.

So you can keep the data and the presentation separate. That gives you a better way to track database size. I normally have the front end compiled before deployment, just for better performance.

 

[GaryPanic]

also see if you have any temp tables ...
if any of your qry/macros create these you ned to tweak it so that on close these are deleted (Unless you need to keep them)

 

[boblarson]

also see if you have any temp tables ...
if any of your qry/macros create these you ned to tweak it so that on close these are deleted (Unless you need to keep them)

But, if you do that, make sure you run Compact and Repair either on close or very frequently because just deleting the tables will not get rid of the space they take up until a Compact and Repair is done.

 

[Les Blair]

Thanks to all of you. I found my problem. I had a query that was to append a single record but somehow it started appending the entire table which did not take long to grow. This has been fixed and should not happen again. Again thank to all.