Shut Off "Always Create Backup" (xlk) feature on Export to XLSX

  • Thread starter Thread starter MJ
  • Start date Start date
M

MJ

Seems that we are running into a problem with the "Always Create Backup"
feature of Excel being set on files exported from Access database. Not sure
why this is all of a sudden becoming a problem, is this a function of the PC
which creates the file, or opens the file first?

If it is in the creation, is there a setting within Access to disable that
feature for the XLSX files that we create on export?

If it is in the opening, what do we need to tell people how to configure
their PCs and Excel for?

Thank you for your time and assistance.
 
MJ said:
Seems that we are running into a problem with the "Always Create Backup"
feature of Excel being set on files exported from Access database. Not
sure
why this is all of a sudden becoming a problem, is this a function of the
PC
which creates the file, or opens the file first?

If it is in the creation, is there a setting within Access to disable that
feature for the XLSX files that we create on export?

If it is in the opening, what do we need to tell people how to configure
their PCs and Excel for?

Thank you for your time and assistance.
Click to expand...
 
.xlsx files creating backups

I'm having this same problem with exports from Access as well as exports from Crystal Reports 9. It seems that .xls files will not create automatic backups of themselves, but the .xlsx files do create automatic backups of themselves. I've tried the Excel Options, but the backup settings are unchecked.

Any ideas, anyone?

Thanks so much,
Lisa Johnson
Western Michigan University
 
Back
Top