Re: [MS_AccessPros] Is it necessary to compact/repair a frontend with extension as "accde"?

 

Kevin-

I generally avoid Compact on Close because it was suspected to cause corruption, particularly if done in a shared database.

Unless you're using temp tables in the local copy (DELETE *, load with new data, use in a report), you should have no need to compact the front end.

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications 

SQL Queries for Mere Mortals 

http://www.viescas.com/ 

(Paris, France)

On Mar 5, 2014, at 3:39 AM, qingqinga@yahoo.com wrote:

Dear All,

I have a frontend "hotel.accde", and a backend "hotel_be.accdb". All actual tables are stored in the backend.

My question: is it necessary to set the frontend "hotel.accde" as "Compact on close"? , if I chose not to compact on close, will it affect or damage the backend?  Thanks in advance!

Best Regards,

Kevin

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (2)

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___