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 / Forms Programming / February 2007

Tip: Looking for answers? Try searching our database.

Front-end Databases

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Jeffry Montalvo - 26 Feb 2007 20:47 GMT
Hello Everyone,
My question is quite simple. I have frontend databases in 8 locations in a
network. Do I have to go to each computer and update each one when I make
changes to the forms?

Thanks,
JM
Michel Walsh - 26 Feb 2007 20:54 GMT
Yes, and no. Each computer has to be updated, but you don't necessary have
to move to each station. There are some 'tools' out there that allow you to
do it almost automatically, as example, check the Front End Updater at
http://www.granite.ab.ca/accsmstr.htm  (It assumes that the database is
split into a back end, the data, and the front end, the presentation).

Hoping it may help,
Vanderghast, Access MVP

> Hello Everyone,
> My question is quite simple. I have frontend databases in 8 locations in a
[quoted text clipped - 3 lines]
> Thanks,
> JM
kingston - 26 Feb 2007 21:08 GMT
Yes, unless you have a different delivery mechanism (other than yourself).

You can set up a "download" or "updates" folder on the network that people
can access.  Then they can replace the front-end file themselves.  Or you can
e-mail them the updates if your mail server allows it.  You can also write a
routine into the front-end that checks for updates and replaces objects (e.g.
forms) when the user first opens the file.  There are probably a lot of other
ways to do this; HTH

>Hello Everyone,
>My question is quite simple. I have frontend databases in 8 locations in a
[quoted text clipped - 3 lines]
>Thanks,
>JM
Albert D. Kallal - 26 Feb 2007 21:53 GMT
> Hello Everyone,
> My question is quite simple. I have frontend databases in 8 locations in a
> network. Do I have to go to each computer and update each one when I make
> changes to the forms?

If you need to update your word program to the next version, you have to go
to each machine and update it. The same goes for most software, and that
includes the software your team of developers and analysts is making. You
are deploying software to those machines, and like all other software, you
need to either go to each machine, or your software can provide some type of
automated update system.

Signature

Albert D. Kallal    (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal@msn.com

 
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.