Question How to backup, restore, import/export from access 2007 packaged solution

[Richardabichahla]

Dear all,

I have a packaged access 2007 solution (using access developer's extensions) and i need to add to my users the backup/restore database feature and the import/export feature.

kindly note that this is available in the access 2007 normal version ( not packaged).

thank you,

 

[HiTechCoach]

Dear all,

I have a packaged access 2007 solution (using access developer's extensions) and i need to add to my users the backup/restore database feature and the import/export feature.

kindly note that this is available in the access 2007 normal version ( not packaged).

thank you,

I think you are referring to Access in Runtime mode.

See:


Export to Excel not available

Ribbon Wizards


Hopefully your database is split into a front end and back end. The backup on the Access menu only backups up the current opened database. It does NOT back up the back end. I would recommend adding custom VBA code to perform the backup since you need to check to be sure the back end is not in use before attempting to back it up.