Re: upgrading to newest version

I made a small program to update frontend like this, you can try it here:

Best regards,
Alex Dybenko (MVP)

"Steve" <webmail@xxxxxxxxxxxxxxxxx> wrote in message news:uhAwDXiKHHA.4460@xxxxxxxxxxxxxxxxxxxxxxx
I have an Access ADP and there are about 10 users that use the program. Currently, I am managing the program by having the ADP's for each user located on the server and their desktops have a shortcut to their respective ADPs. However, I know this creates additional network traffic and slows down the performance of the program because it is running across the network.

What I should do is have the ADP and an executable on their respective desktops. They run the ADP from the executable, but it first checks to see if the ADP version on their desktop is the same version as the master on the server. If it is NOT, then it copies the newer ADP from the server to their local computer and then runs the program.

The problem is that I do not know how to write/create this code. I remember seeing it on the web a long time ago. Does anyone have a copy of simple code that does this and instructions on how to set this up?



Relevant Pages

  • Re: ADP Applications
    ... put more of the business logic on the server. ... But the benefit was that Access could produce applications that would take 10 times as long in Dbase and ran way more efficiently. ... ADP vs .Net, as you don't store the data in the client, neither ...
  • Re: porting Access to SQL Server --- what to do with the front-end?
    ... ADPs connect to MS-SQL Server using ADO / OLEDB. ... Internet or Network enabled. ... I have a shortcut on my desktop to an ADP. ...
  • Re: ADP freezes when it cant find SQL Server
    ... « ODBC is well known for duplicating server values; however, ... problem for you because ADP use OLEDB, not ODBC. ... a problem for you because ADP use OLEDB, ... I have one ADP file that will not open at all. ...
  • Re: Access 2003 to SQL Server 2000 over a VPN
    ... sufficiently fast response times, ADP may be a good enough client, ... Replication can be another solution, ... you're careful about your database design, though, that may be the way to ... As a result of the difficulties I've had, I try to avoid SQL Server ...
  • Re: Quick Access 2003 ADP/SQL Server 2005 question
    ... you are a liar and a retard. ... ADP wins in _EVERY_ regard. ... If you need to use a server database engine ... It's then generally pretty easy to modify the query so that ...