We have a smart client application with an embedded MS Access database.
As we put out auto-updates for the application, at some point we also need
to update the Access database schema that's on the client.
This would involve backing up the user's existing data, installing the new
database schema and then copying user's data back into the new schema.
Can anyone recommend best ways to do this? Either writing our own code or
possibly looking at 3rd party tools who may provide this functionality.
Thank you!