Comp & Rep (1 Viewer)

[Kundan]

How to Compact & Repair back-end from front-end through code?

 

[vba_php]

do any of these work?

https://www.access-programmers.co.uk/forums/threads/code-compact-and-repair-backend.228573/

https://www.access-programmers.co.uk/forums/threads/compact-repair-backend-db.39833/

https://answers.microsoft.com/en-us...ase-from/06b20e7d-119a-4c02-acac-8db38fdd923d

 

[The_Doc_Man]

While it is theoretically possible to do this, the fact that you have a front-end open very often means that the back-end is also open. Normally, you will require exclusive access to the BE to do a Compact & Repair. If even one other person has the FE open, you will NOT be able to do this at all. Even if they aren't doing anything, having the BE open by two users is enough to deny lock conversion from Shared to Exclusive. Without that lock conversion, you are dead in the water.

The way that I always did this was that we had a time set aside every other week so that we could take down the DB completely in order to manually perform the C&R.

 

[Kundan]

do any of these work?

https://www.access-programmers.co.uk/forums/threads/code-compact-and-repair-backend.228573/

https://www.access-programmers.co.uk/forums/threads/compact-repair-backend-db.39833/

https://answers.microsoft.com/en-us...ase-from/06b20e7d-119a-4c02-acac-8db38fdd923d

Thanks. GOD BLESS YOU!!!!!!!!!!!

 

[vba_php]

...........

 

[theDBguy]

How to Compact & Repair back-end from front-end through code?

Hi. Not really sure why you need to do this, but you might also consider looking at this code for backing up and compacting the BE.

 

[Kundan]

While it is theoretically possible to do this, the fact that you have a front-end open very often means that the back-end is also open. Normally, you will require exclusive access to the BE to do a Compact & Repair. If even one other person has the FE open, you will NOT be able to do this at all. Even if they aren't doing anything, having the BE open by two users is enough to deny lock conversion from Shared to Exclusive. Without that lock conversion, you are dead in the water.

The way that I always did this was that we had a time set aside every other week so that we could take down the DB completely in order to manually perform the C&R.

Thanks. GOD BLESS YOU!!!!!!!!!!!

Hi. Not really sure why you need to do this, but you might also consider looking at this code for backing up and compacting the BE.

Thanks. GOD BLESS YOU!!!!!!!!!!!