update MDE

[fule12]

Hi to ALL,
I found one link :

http://www.netfolk.co.uk/netfolk/access/dbans.html

Where is code for automatically update of local MDE. But in his code is question about
secured.mdw and you nead to create new DB.

What i nead is same simle code what is gona check ver. of MDE on server with ver of MDE on local machine and make update.

So if anyone have samething like this please help me !!!
Thanks Fule

 

[oharab]

Have a look at my FAQ:faq705-2010

It's my way of doing it. If you wany any more help, just ask.

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.police.uk
----------------------------------

 

[fule12]

Hi,
Thank for replay but this is not working with Access 2000.
In line :
fHandleFile GetDBLocation & "UpdateFrontEnd.vbs", WIN_NORMAL
I have error on :
FHandleFile - Compile error:
Sub or Fuction not defined.
but from Tools -> Reference i dont know with Reference to select?

Thanks Fule

 

[oharab]

Oh yeah, you need to get the code from another of my FAQ's:faq705-1971
Just copy the code into a seperate module and everything should be ok. This code lets you run any file without specifying the application to run it with. You can use it for running any file you can double click on. If it doesn't know what application to use, it asks you.

B ----------------------------------
Ben O'Hara
bo104@westyorkshire.pnn.police.uk
----------------------------------