Updating distributed applications

[Seamus59]

I am sure this has been solved, so if someone could point me to the appropriate thread...

How do I make provisions for updating software I've written? I have someone testing my software, and they are catching bugs and making suggestions for improvement. I need to be able to send an updated version to them later that will update their application without losing their data. Is there a more elegant or simple way than my code just importing tables from the old database and renaming files?

Thanks.

[rpeare]

If you are not altering the structure of your tables the easiest method is to split your database into a front end (the user interface) and a backend (the data tables). Access has a database splitter utility that will do it for you.

So if you alter anything in your front end all you have to do is copy your 'new' front end over that, re-establish the links (this can be done with code as well) and you're all set to go.

[Seamus59]

I figured it would be about that simple. Thanks. Now I just need to learn how to handle the links. I appreciate it.