Update File - Access Database

[stustarz]

Does anyone know if it is possible to create an update file for an access database that users can download?

 

[Robby]

Can you explain with some detail please.

 

[stustarz]

Yeah! sorry!

I have an application that retrieves its data from a Microsoft Access database - when I update the database I dont really want to have to make my users download the entire database again simply download an update file that will amend, add or delect the required records in their version of the database.

 

[a_jam_sandwich]

You could create a SQL file with all the updates in it

Once this file is downloaded. Open and run through the file, running the SQL commands as you go

Andy