Updating and existing Database

[cocoonfx]

Hello


I have a database which i am constantly updating and improving. I have a few friends who use the database in a current form. If i made an update say to a form or to some of the coding to make the DB more efficent, how can i update the dBs my friends are using without damaging or changing the existing data, or migrating it to the new design.

I.e going from version 1 to version 1.1

Any advise would be great?

 

[Len Boorman]

Basically you need to preserve the data

So

Delete all Forms, Queries,Reports, Macros etc and then Import a complete new set from your updated version.

This will be okay providing you have not changed Tables or Relationships.

If you have added filelds to tables then you need to manually add those as well making sure you maintain data types and sizes.

If you have changed relationships then you need to amend those as well but also need to ask why they were changed. Changes here would indicate a flawed design.

Only then leaves any new tables you have created as part of additional functionality. These can be imported as previously mentioned and then manual make the relationships

L

 

[jkl0]

You should consider splitting the DB into Front-End (forms, queries, reports, modules, etc.) and Back-End (data tables), then any changes you make to the front end would not affect their back end data.

Hope this helps?

 

[cocoonfx]

Hi

Thank you for the advise the back end does make more sense just thinking of it.

The only thing i need to ask if i have two queries which do some calculations and then they make 2 tables which 2 reports are run off. How would i get the make table queries transfer into the back end??

 

[gold007eye]

If you are using a make table query as temporary tables for reports to run off of then you wouldn't need them to be sent to the back-end in this scenario. Just set it so that once the report has been created with all required data have a query that will delete the temporary tables.

 

[cocoonfx]

This has just made me realise that i have designed my origin DB badly as the main table i have created two queries as i could't get the table use a formula i created a unique number as a default value.

So if you took query 1 was for one form which sent information to the make 1 of the make table query which then created the new table which drives the reports and a summary.

Oh this is not good.

Prehaps need to look at possibly redesigning the whole thing.

Does anyone have any suggestions where i can get the make table happen in the back end.