How do I update Access 2003 with changes?

[tom26pr]

Hi there,

I have the folloiwng issue.
I have implemented major changes to the application's forms (Access 2003 DB), mods, tables, queries (design part) and so on.
I need to update the client's application with those changes but I cannot (for instance) change the actuall data in the tables. So the only changes in question are those design ones... (for instance, I will need to add a few fields to a particular table but I cannot change the content of the existing columns, so the customer doesn't lose any recent data).
I know that 'replica' could be an option here; however it would result in changing content of the tables along with the design changes whoch is not desired...

Any idea?

Thanks in advance.

[marcf]

Hi,

I wouldnt say i'm an access guru but to me the safest and simplest solution is to simply import their data into your new version.

Providing you've only added columns and cnot hanged the existing ones it should be very easy!

Let me know if you have any other questions.

[tom26pr]

marcf...

Thanks a lot. This is what I am going to do. I will simply import it. I don't think I can change the shape of a table without changing its data content (using 'synch' option).
Thanks for your reply.

[marcf]

yeah that way you can also have a look at the data its imported and check its all done ok, the only way it will throw up errors is if you've Changed the type of field, the length of field or input masks.