Checking for correct front end version help.

[MunroeM]

Hello all.



I have a database that is split front end(FE) and back end(BE). The BE is in a seperate location away from users eyes and the FE is distrubited via email to the required users.

How can I ensure that when I make changes to the FE and send them the new version that they can only access the BE with the correct FE version.

I was thinking of making a new table in the BE that would have the current version number in the table and the FE would also have a version number. Then with the FE i would use the on load function to do a check to ensure that the FE and BE version numbers match up. If they dont it would tell them to get the correct version and close access.

thats my Idea i just cant seem to work out how to do it.

P.S. I have seen the autoFEupdater website but that is not an option for me. as nice as it would be

Thanks

[orange]

See this info from DevHut There is code in the Automatically Deploy a New Access Client in the Danny Lesandrini link.

[MunroeM]

Thanks alot Orange.

I do like the Danny Lesandrini link but i was wondering if you could help me out with modifying it to fit my needs.

here is the link so you can see the code he uses http://www.databasejournal.com/featu...ess-Client.htm

The main problem im having is in the "preforming the update" section. mainly the StrDest portion. I'm assuming that when he designed it users would be putting copies of the ClientDB.mdb in the same drive. For me lets say users would be putting the clientDB.mdb copy in a different drive and not everyone will put it in the same location as the other users(ex. user 1 places it in G:\personalfolder, user 2 places it in C:\Desktop, User 3 places it in M Drive somewhere...) How can i make it so the StrDest actually selects where the clientDB.mdb is? the main problem for me is that the update.mdb is what this code is in and i dont know how to select where the user copied their client.mdb to...

Its late and i'v been looking at this problem for several hours and this might all look like jibberish to anyone else but this is the best i can explain my situation.

any help is wonderful

thnaks