Question One BE, multiple FEs

[mikekeller987]

I have a central BE on a networked server and I keep hearing a strong suggestion to run FEs on every user computer to prevent data corruption.

What I want to do is to Automatically update the FE to the most current version each time the user clicks on the icon on there desktop.
I'm running Access 2010.

How do I do this?

 

[Beetle]

Have a look at Bob Larson's auto FE update tool here.

 

[pbaldy]

I use a local table in the front end and the user runs a little exe I write that checks that and updates if necessary. My buddy Bill uses script:

http://www.thatlldoit.com/Pages/howtosarticles.aspx#feupdate

Bob has a utility:

http://www.btabdevelopment.com/ts/freetools

 

[pbaldy]

Dang these slow fingers!

 

[mdlueck]

I rolled my own Software Distribution solution, described here:

FE AutoUpdate with RoboCopy / XCopy
http://www.access-programmers.co.uk/forums/showthread.php?p=1214733#post1214733

Prior to deploying an updated FE, I run through these FE cleanup steps:

VBA to Cleanup A2007 DB Extra Objects
http://www.access-programmers.co.uk/forums/showthread.php?t=226466

NT Command Script and Documented Steps to Decompile / Compact / Compile an Access DB
http://www.access-programmers.co.uk...to_Decompile_/_Compact_/_Compile_an_Access_DB

 

[mikekeller987]

pbaldy:

I have read through your vbscript solution and I like it.
I will be attempting to implement it into a Win7 x64 Domain network using Access 2010.
I will return here after and let you know how it went.

Thank you - Mike

 

[pbaldy]

Happy to help, but credit goes to Bill. If you get stuck, I can pass on any questions we don't know the answer to.