How to stop access from adding 'create a backup' when exporting to excel?

Question

Hi, 

I regularly need to export access 2007 data into Excel 2007 in order to distribute to some colleagues, but the wizard adds a backup option each time.

I don't wish for this to happen on any of the exports but I can't find a check box anywhere to identify how to remove it (other than going into Save As > Tools > General Options ? remove the check from 'always create a backup'

How can this be done please so that backups are not created on export?

Thanks,

Su

Answer 1

HI Nathan,

the backup is only created when you open the excel sheet and save it as something.

I could go into Save As > Tools> General Options and uncheck the 'create a back up' every time but I don't want to have to do this - I need a way of telling Access / Excel NOT to have this checked as default. 

I'm not sure it can be done, becuase I read on the microsoft website that this is a 'feature' (in other words it's a bug that they can't resolve so are turning it into a feature to make it sound like something people actually want!!).

Su

Answer 2

Hi Su,

If the option you are referring to is within the Excel file itself, you may want to try posting your question on the Excel forum.  They may be able to provide you with some suggestions.

Best Regards,

Nathan Ost

Microsoft Online Community Support

Answer 3

Hi SuStinchcombe,

What steps are you taking to export your data from Access to Excel?  When I open an Access database in Access 2007 and right click on a table and choose Export -> Excel, I don’t see the backup option you are referring to.

Best Regards,

Nathan Ost

Microsoft Online Community Support