hi there all

I know this should go in the Database forum, but it's like a graveyard!

Anyway, I am making a data app that uses an Access database to store data. Thing is, at some stage I will want to update my program (users might have suggestions) and as all of you know, if I simply replaced the old database with a new one, the data would be gone!

So does anyone have any suggestions as to how I might go about updating the database file with a new structure, but keeping the data? Is it possible to just copy the data over to a new blank database with the new structure?

By the way - end users may or may not have Access installed and I can't go to their machines to fiddle, it all has to be programatic. I hope to simply distribute an EXE that will do it all.

All help much appreciated...

Regards,

------------------
- Chris
[email protected]
If it ain't broke - don't fix it