Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » New .mdb file created when compacting a .accdb file

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

New .mdb file created when compacting a .accdb file

Resolved · High Priority · Version 2007

Reply Mon 26 Jan 2009, 10:33Delegate Sarah said...

Sarah has attended:
Access Intermediate course
Access Intermediate course
Access Advanced course
Project Management 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

For upcoming training course dates see: Pricing & availability

Reply 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.

Access articles

· Help Business To Go Global With Shared Databases
· Guide To Adding A Text Box Form Control In Access 2010
· Learn The Secrets About Splitting An Access Database
· How To Create Calculated Fields In Access 2010 Tables
· Record, Find And View Data Easily Thanks To Microsoft Access

Please browse our web site to find out more about
courses in microsoft access and other Microsoft training courses.

Access tip:

Change The Default Font in Access 2003

You can change the default font in Access 2003 so that whenever you create a new database your preferred font is automatically set.

To change the default font:

1.From the menu bar select Tools.
2.Click Options.
3.Go to the Datasheet tab:
4.In the Default font section select your preferred font from the list of fonts e.g. Arial.
5.Select your preferred size from the size menu e.g. 12.
6.Click Apply.

Click on the Tables/queries tab:
1.In the Query Design font section select your preferred font from the list of fonts e.g. Arial.
2.Select your preferred size from the size menu e.g. 12.
3.Click Apply.
4.Click OK.

The default font for Access has now been changed.

View all Access hints and tips