Sarah has attended:
Access Intermediate course
Access Intermediate course
Access Advanced course
Project Management - Framework & Processes course
New .mdb file created when compacting a .accdb file
I have set the front end of our database to compact on close. This feature works great for many users however we have one user's front end that upon close, results in a new compacted version of their front end but as a .mdb format rather than the standard .accdb format that we all use.
I cannot figure out how this is happening - everyone has Access 2007 and so I am wondering whether I have missed a vital setting that this one user needs to have changed.
Any help much appreciated!
Thanks
RE: New .mdb file created when compacting a .accdb file
Dear Sarah
Thank you for attending Access courses!! I hope you enjoyed the courses and benefited from them.
Please go to the workstation that is saving the file as .mdb and check the following option:
Office Button > Access Options. In the Popular category please see if the Default file format is set to Access 2007 and NOT Access 2002- 2003.
That is the only thing I assume is causing that problem to occur.
he following link may help you in getting some answers about Compacting and repairing database:
http://office.microsoft.com/en-gb/access/HA102355831033.aspx?pid=CH100948231033 #3.1
If you scroll all the way down to the end of the page of the above link you can see all the other related topics for compacting and repairing which may be of some help to you!!
I hope this has answered your query.
If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!
Kindest Regards
Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
