Compacting a split database

[nq]

I have a multiuser database installed on a network. The database is split into a front end and two backends. The backend files reside on the server for communal access. All users have a copy of the frontend on their respective workstations. The frontend file contains temporary tables to perform various functions.

As part of good housekeeping, the "compact and repair databae" function is used occasionaly to compact the db. Performing this from a user frontend, appears to ONLY compact the frontend file, not the two backend files. The compact function seems to ignore the fact that there are linked tables. The compacting function must be run on each backend file seperately.

I am thinking of automating the compact function programaticaly. Must this be done for every file or is there some switch or information that I'm missing?

Nigel.

 

[lupins46]

There is no secret switch.

You can't have the backend being compacted automatically on close of frontend in a multi-user setup - other users might still be active.

You have to build a procedure (manual or code-based)to do the backend compact.

 

[nq]

Hmm....

I would assume that Access is smart enough to deny compacting if there is an active user in a multiuser environment. Perhaps not?

So, no secret switch! Alas, I fear magic is fast fading from this world.