moving data from one access database to another 1

[kaiana]

I have a data base (access) that we have distributed as a runtime application. I now need to distribute version 2 of the data base. The new backend contains 2 new tables and one new form. How do I create an updater that will move data including relationships and autonumber. and will work in runtime.

Thanks in advance for any sugestions

Jason Spence

"A smile costs nothing to give but can be everything to recieve"

 

[KenReay]

Hi

Not too sure about the runtime bit, because I have not done this using runtime, but how about adding some code to your frontend which tests for the present of the tables in question, if they do not exist, then create the tables in the backend, and relink them.

You can create the tabels with SQL DDL statements or via the DAO object model (if you are using DAO), that is Tabledefs, Fields collections etc. Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK