Re: upgrading to newest version

In addition to Alex's solution, there's also what Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"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?

-Stephen



.

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 ...
    (comp.databases.ms-access)
  • 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. ...
    (comp.databases.ms-access)
  • 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. ...
    (microsoft.public.access.adp.sqlserver)
  • 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 ...
    (microsoft.public.access.adp.sqlserver)
  • 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 ...
    (microsoft.public.access.adp.sqlserver)
Loading