Access Without Backend - and updates

[rsearing]

I have been doing quite a bit of research - but nothing that quite answers this question completely - or in a way I can understand (bit of a novice).

I am using MS Access 2007 to create an app for my wife who is running 2003. I had the .mdb split so tables are seperate from forms.

What I would like to know is:

a) How can I make this app - so that it opens without the backend. I see something in 2007 - where I installed the developer addition - and have the 2007 runtime - but can't seem to get it to work. I want it to open without all the tables, menus (ie the backend of Office).

b) Once I have that deployed - how could I redeploy - if I wanted to work on the forms - but keep her tables (data)?

Thank you SO much, in advance,
Rob

 

[jsv2002]

Don't quite understand what you mean but all you do is keep a "master copy" of the FE you have developed and distribute "copies" of this. Then just keep a developement copy of the BE which you need with any split database this can have dummy data in it all you are using is the table structures the BE your wife would be using should be in a different location containing the live data.

Now that said should you make any changes to your "developement" BE such as adding extra tables or fields you would need to update the "working backend" with these Bob Larsons Auto Updater is excellent for this.

However you should do extensive testing on your test backend with dummy data to make sure you do not cause and conflicts when introducing these new tables or structures.

Hope this helps, John

PS. When you relocate your FE/BE you would need to use the linked table manager to find the tables unless you have used something like a folder in root directory to develope say C:\MyDatabase and the new PC/System just copies this to the same location.