distributing a split database problem (1 Viewer)

[groengoen]

I have a split database with a mde front end and mdb backend with all the tables. I added a table to the backend and want to know the best way of distributing the new table. I use the package wizard to create a package to renew the frontend, but I don't want to override what users have done on their existing backend. I see that one can export a table to another mdb but I want to allow the users to do this themselves in a user-friendly way. Is this possible?

 

[DCrake]

Don't know how you have written your front end but if you have an admin screen you could create a "Patches" form and in this example you would include the new table into the front end prior to distribution then when the user select update patch #n you would code it to copy the table to the known back end, delete it from the front end, then link the table.

If the table is already linked (if they try to run it again) you can ask them if they want to overwrite the existing table.

David

 

[groengoen]

That sounds like what I want. I will give it a try, Thanks