update database 2

[nickbar]

I have a database that is currently being used 'in anger' and has a lot of data within its tables. I now have a new version of the same database with some of the forms revamped and a new form added that I developed on another PC

How do I update the currently used version of the database with the new one yet keep all the data within the tables? Is there an easier way than exporting each form etc individually from the new version to the old?

Sorry if this is a numpty question but I'm new to this lark and still on a steep learning curve.

Many thanks in advance.

Nick

 

[Remou]

If you have a split database, front-end for forms, back-end for data, this all becomes quite easy - you simply relink the tables. It is not too late to split the old database: first, back it up and then use the database splitter wizard, finally, link the back-end tables to the new front-end database.

 

[MajP]

If this is a shared application it should be split as Remou says. If this is for individual use importing should take no more than a couple of minutes. You do not do this individually you import all desired objects at once.
1. Open a brand new database
2. Import all forms, reports, modules from your new database at once. That should take about a minute.
3. Import all tables from your old database. That should take another couple minutes.

 

[Remou]

I usually find that new forms overlap with old forms, that is, some will have the same names, there fore the old forms need to be renamed. Similarly, tables need to be renamed before import of new tables. In addition, relationships will have to be checked. Even for a database used by one or two people, I find it is easier to have a split database, unless there will never be any new development.

 

[nickbar]

Many thanks for your replies. I've tried both ways and for my database it's six of one and half a dozen of the other as to what is the best method. Both will be valuable for the future though. Another little thing learned! Thanks again.