keep multiple access db's forms in sync in 2007?

[Lost500]

hey peeps,
I have multiple access databases linked to a sql database and when i make changes to the forms in my copy i would like it to update the other copies.

in 2003 i used a replica set but i don't think 2007 has the function and it was very buggy to begin with.. or maybe my code was ..

also the access databases have individual datasources, i don't think keeping the forms in sync with my own would reset thier linked tables to be going through my odbc connection but that would be bad...

Thanks for the help in advance!!

 

[maxhugen]

Did something like this years ago, don't know if it will help you but...

1. add program_version table to sql database
2. when you update prog, also update program_version table.
3. store updated prog in specific location on server
4. when prog opens, check it's version against program version in sql database.
5. if it needs updating, advise user, then open an 'Updater' mdb to do the updating, and close prog.
6. 'Updater' mdb copies updated prog from server to user's prog location
7. 'Updater' mdb re-opens prog, and closes itself.

Took me a few hours to set this up, but it worked really well.

HTH

Max Hugen
Australia