Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Developer Toolkits / December 2006

Tip: Looking for answers? Try searching our database.

upgrading to newest version

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 28 Dec 2006 02:13 GMT
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
Alex Dybenko - 28 Dec 2006 12:06 GMT
Hi,
I made a small program to update frontend like this, you can try it here:
http://www.pointltd.com/Products/Details.asp?dlID=35

Signature

Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

>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
[quoted text clipped - 14 lines]
>
> -Stephen
Douglas J. Steele - 28 Dec 2006 12:34 GMT
In addition to Alex's solution, there's also what Tony Toews has at
http://www.granite.ab.ca/access/autofe.htm

Signature

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

>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
[quoted text clipped - 14 lines]
>
> -Stephen
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.