Is Compact and Repair Needed - Microsoft Access SQL Server Online


	Back to Access SQL Server Online Comments List

Upload Images @Reply Bookmark Link Email

Is Compact and Repair Needed

Margaret Simcoe

3 years ago

Our in-house access database sometimes becomes unstable and I need to kick everyone out so I can compact and repair the database. Is there some way to do that with Access SQL Server Online? Is it necessary?

	Alex Hedley @Reply 3 years ago
Look at Maintenance Plans

	Richard Rost @Reply 3 years ago
In a nutshell, no, you should never have to compact/repair an SQL Server database. It's pretty self-maintaining. If a compact/repair is fixing things for you, I suspect maybe your front-end file is somehow getting corrupted. Is everyone sharing the same file, or do you have it properly split and everyone has their own front-end ACCDB file?

	Margaret Simcoe OP @Reply 3 years ago
Thanks so much for your reply. I have it properly split. I inherited a large complex database some 10 years ago and I'm hoping to simplify the system as I convert it and get rid of anything that might be corrupting things.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access SQL Server Online.