Problem with Bob Larson Auto Update prog

[tonytlc]

Hi
I am new to this forum so forgive me if I do not follow the rules.
I have downloaded and installed Bob Larson prog for auto updating the front end of my database. On my computer all works fine but when I copy the FE to other computers it simply opens even when I change the version numbers. In other words it does not seem to be doing the comparison. The paths I am using are:

Local - C:\Documents and Settings\All Users\Documents\The_Laura_Centre_PCT_Dbase
Server Location - \\server\server drive\The_Laura_Centre_PCT_Dbase\Front End

I have double checked the paths on the local machines and they are all the same and yet it only works on my local computer.

Any help would be REALLY gratefully received as, at the moment, I am still having to run round the building updating everyone which involves lots of stairs.

 

[DJkarl]

Do you and your users have the same permissions to the server drive? MS Access requires full permissions in order to work properly (Read/Write/Delete/Modify).

 

[rainman89]

It does not error or anything when you try to open it? Are you sure the code in the onload event of your startup form is running?

Check the table in the frontend that has the location of the backend database and make sure it is correct.

 

[jsv2002]

As I iunderstand the app you wouldn't copy the FE to other machines but have a collective folder on the network to store the update. All of the other front ends should have this path set to look for their "current" version on open.

This information is stored in the "tbl-version_master_location" in a local table on the front ends.

Then in the backend you change the version number in table "tbl-version_fe_master" making sure your updated front end is in the specified update folder.

When I don't have access to the back end myself eg. another office location I set up a "Maintenance Form" with a control to alter the version number to that advised making sure the person is aware to copy the "update" to the appropriate folder first.

Hope it makes some kind of sense.... good luck john

 

[tonytlc]

Thanks for the replies guys. I am not getting any error messages in fact nothing at all happens. I have checked the paths and made sure that, on all of the local machines, the FE is stored in the same folder with the same path (I have created a folder in the shared documents folder). The puzzling thing is that it works on mine perfectly but on the others, as already mentioned, nothing at all happens. The DB just opens. Until I can solve this I have reverted back to an executable RAR file with the extract path set.
If you can think of anything else I would be eternally grateful as I am getting a little too close to the "pulling hair out" mood.
Oh how I love computers and Dbases!!

 

[raskew]

Don't know if you're aware, but Bob Larson no longer participates in this forum. You can find him at Utter Access, and you may want to post your concerns there.

HTH - Bob

 

[tonytlc]

Thanks very much for the info. I'll try posting the problem there as well.
Thanks again

 

[SOS]

You might also try the support forum for his tools on his website:

http://www.btabdevelopment.com/main/Forum/tabid/114/forumid/14/scope/threads/Default.aspx