Backup and restore in access 2007 packaged solution

[Richardabichahla]

Dear All,

I have a packaged access program where i need to create a backup / restore feature, can anyone help please ??

thank you

 

[HiTechCoach]

Dear All,

I have a packaged access program where i need to create a backup / restore feature, can anyone help please ??

thank you

What you mean by "packaged access program"?

Is your app split?

Maybe one of these will help:

Example 1

Example 2

Example 3

 

[Richardabichahla]

What you mean by "packaged access program"?

Is your app split?

Maybe one of these will help:

Example 1

Example 2

Example 3

I mean by packaged solution that i downloaded access developers extensions and i packaged the solution so the user can only see the forms and report. this will disable the ribbon so the user can t see the tables design view or code.
disabling the ribbon disable the backup and export features with it. to have them back you need to create a custom ribbon and its buttons.
In 2007 this needs VBA coding that i don t know.

BTW i also tried to use the ActiveX controls i got a pop up that OLE server is not available, How can u i get it ??

 

[HiTechCoach]

I was thinking this sounded familiar.

Your previous threads on this same topic:

6/7/2010:
How to backup, restore, import/export from access 2007 packaged solution

I replied:

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.

6/8/2010:
You responded with a new thread:

Backup/restore backup in access 2007 runtime

You were given a method to do a backup and restore of Access object that could be used on the tables ion a back end.

My guess is that they did not understand what you wanted or you did not understand their answer.

I think it was not the answer you were looking for so you started over again with this thread.

Now that we have all this history in a single thread, hopefully it will be easy for other to follow and help:


Split your Access database into application and data

This becomes very important for deployed applications and for doing backups of the data! Especially if you want to restore the data.

I run all my Access Apps split with the front ends with Access in Runtime mode. This is true is the PC has the full version of Access installed.

How are you currently restoring when Access is not in runtime mode?

As far as I know, Access only has a built in ability to backup the currently opened database. There is not a restore feature built into Access.


To help you, it is very critial to know a few things:

1) Is your app split into a front end and back end?

2) What are you wanting to back up and restore? Please be specific and detailed about how it should work.

Please answer these two questions.