Code to overwrite local user's front end w/more recent versi

[jdowski]

Hi,

I used to work at this other company where that had a database on the network. The back end was all the tables. The front end lived on each user's desktop. There was a master front end on the network. If I needed to make a change to a form or report I would change it in the master and then the next time a user logged in, code would run that would look at the modification date of the master front end and if it was more recent that the mod date of the local user's, it copied the master front end overtop of the local user's. This way all the changes flowed from one place, the master front end.

Sound Familiar ???

Thanks very much in advance !!!

 

[Norie]

Where was this code being run from?

The master frontend?

 

[jdowski]

Re: Code to overwrite local user's front end w/more recent v

I just called someone at my old company...It's actually a VB executeable that is called from the local front end ??? Not totally sure....he's going to send me a copy of the VB executable but I don't think I'm going to be able to get into the code to see what it's doing...

Have you heard of code like this though ???

J.

 

[Norie]

I thought it might be something like that.

I suppose it would be possible to write such code but it might be quite difficult, especially if your dealing with users on a network.

If you are working on a network maybe you could speak to some network person to set something up so the user automatically has the most up to date version of the frontend.

 

[jdowski]

Re: Code to overwrite local user's front end w/more recent v

Well I haven't heard from my friend so I did a little surfing on the net and came up with a solution. I have a batch file that will copy the master front end to/over the local user's version. The user would have to remember to hit the batch file before opening Access but the file itself runs very quickly. I might even be able to call the batch file itself from Access after it checks the mod date of the master FE to the local FE. If the master FE is newer, it will close and call the batch file....?....we'll see