How to compact the back end database?
For the FE we normally use this :
Automatically compact and repair a database when it closes
You can select the Compact on Close database option if you want to automatically compact and repair a database when it closes.
NOTE: Setting this option affects only the database that is currently open. You must set this option separately for each database that you want to automatically compact and repair.
On the File tab, click Options.
In the Access Options dialog box, click Current Database.
Under Application Options, select the Compact on Close check box
WHAT ABOUT THE BE (BACK END)??????
Regards
Chris
Automatically compact and repair a database when it closes
You can select the Compact on Close database option if you want to automatically compact and repair a database when it closes.
NOTE: Setting this option affects only the database that is currently open. You must set this option separately for each database that you want to automatically compact and repair.
On the File tab, click Options.
In the Access Options dialog box, click Current Database.
Under Application Options, select the Compact on Close check box
WHAT ABOUT THE BE (BACK END)??????
Regards
Chris
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Member_2_7948725,
I can't speak for the others but I grew up in an era where we actually earned our trophies so I prefer to not be awarded participation points.
When you award everyone participation points even though the advice is conflicting, you make the question useless for people who come across it later because they have no idea which suggestion was actually helpful.
I can't speak for the others but I grew up in an era where we actually earned our trophies so I prefer to not be awarded participation points.
When you award everyone participation points even though the advice is conflicting, you make the question useless for people who come across it later because they have no idea which suggestion was actually helpful.
ASKER