I am about to split the first of many databases that desperately need it. This DB will be used at 35 stations in the office. I get the concept of what is stored on the server and what is stored on the user’s hard drive. Since we will frequently need to make design changes to the
front end, I’m looking for the best, simplest and fastest method of distributing the most recent version to users.
I learned in a chat room yesterday, that some people include a table in both the front and back ends that holds the version number. On open of
the front end, it compares the version number. If they match, everything proceeds as usual. If they don’t match, the user sees a msgbox that the database will be closed for updating. After that, theylost me….
I’m told that code exists to update the user’s front end and doesn’t need push technology, but I haven’t found an example anywhere. Can anyone point me in the right direction? Thanks for your help.
I’m using Access XP and WindowsNT 4.0.