Compacting Database

[Carrie]

Hello

I was wondering if anyone could give me any tips on compacting databases.

I've just completed my database and I plan to split it and put the backend on the server and the front end on everyones computer on their c drive.

Originally I thought all I'd have to do is compact the backend as this is the only thing that updates. But having read through some posts I've realised that maybe I should also compact the front end too.

Have had a look on the forum and have got more confused! I don't undestand how to compact the front end as obviously everyone has it on their c drive and I won't beable to access each front end and compact each front. Can each user compact their own front end or is there issues because it's linked to the BE?

What is the recommended way of compacting/dealing with this issue in this instance?

I use 97.

Any help will be appreciated

Carrie

 

[ghudson]

Access 97 db's can not be compacted using code while you are in the db. You could give your users a shortcut that will repair and compact the db. Here is a sample Target: field for a custom shortcut to do just that...

"C:\Program Files\Microsoft Office\Office\msaccess.exe" "C:\DatabasesTest.mdb" /excl /repair /compact

Check the help files for "Startup Command-line Options" for more info on the / commands.

HTH

 

[Carrie]

Hi

Thanks for replying. I will give that code a go.

Can I just clarify what I think I do. The code provided will mean the users will be able to compact their personal front ends whenever?

Regarding the backend I will just compact that when nobody is using the database.

Is my line of thinking correct!

As you can tell I'm a bit confused!!!

Carrie