Database Updates

[cross5900]

Back at you guys with hopefully one more question (btw the command button code worked perfectly thanks)

Another thing my database has to be setup for is updates, Roughly 30 people will be using this database and to have them re-copy and paste the new database releases is out of the questions.

Does anyone have experience setting up code that automatically checks the version of the database created and if it differs downloads/installs the new version and the restarts the database so the associate will then be working in the current version?

I am looking to be pointed in the right direction to get this figured out, thanks.

 

[JoeCruse]

I've not done it, because I only deal with a few workstations. Others here have some good solutions for this. Do a search on this topic and you'll find some good stuff.

 

[The_Doc_Man]

As an addendum, you need to do what is called a "split" database - into a front end and a back end. The back end holds the tables. The front end holds the user interface. As long as no table formats change, it is easy to tell the user to go to some particular place on your shared file server and copy the front end. Note that if table formats change, what you asked is nowhere near so simple. I would not advise allowing this to happen too often.

 

[cross5900]

Yeah, Ive gotten this taken care of. We have a backend/frontend version now, with a seperate database that directs to the current version. So I am fully automated now, just took a lot of reading and looking at various code we have in our office. Complete with a .msi installer to help the "illiterates".