98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » New .mdb file created when compacting a .accdb file
New .mdb file created when compacting a .accdb file
Resolved · High Priority · Version 2007
Mon 26 Jan 2009, 10:33Delegate Sarah said...
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
Wed 28 Jan 2009, 14:44Trainer Rajeev said...
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
Tue 3 Feb 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Hiding rows and columnsTo hide a column or row in Access, you need to minimise the column or row. This can be done by placing your mouse on the right edge of a column, wait for the mouse to change to a double aroow and then drag to minimise the column |
