[AccessD] Replication as a tool for updating FE

Dan Waters df.waters at comcast.net
Tue Sep 7 11:54:29 CDT 2010


Look at:

http://autofeupdater.com/

You can also make your own!  I use a separate .mdb file to copy files from a
source folder on the server to the user's folder when a user wants to open
the app.  This is helpful because if you have a specific situation you can
get it resolved with your own solution.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert
Sent: Tuesday, September 07, 2010 11:28 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Replication as a tool for updating FE

Speaking from experience in Access 97 land, this is surely not a good idea.

On the face of it it looks great, but the problem is that every time you
make a change (in the design master) to any objects in the front end, forms,
modules, report, queries, etc. records are written to an MSYS table to which
you have no edit rights, and the size of that table grows rather rapidly as
you develop the application. The end result is uncontrollable bloat. 

I  would stick with the various front-end updater solutions that are "out
there".  Anyone care to point to a current, active link to the FE Updater?

Lambert

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jennifer Gross
Sent: Tuesday, September 07, 2010 11:45 AM
To: AccessD List
Subject: [AccessD] Replication as a tool for updating FE

It has been suggested to me to use Replication to keep the FE version up to
date.  I have never used replication for data and didn't even consider it
for the FE/code side of things.  Does anyone have any experience with
Replication as the means of propagating changes to the FE?

 

Jennifer Gross

 

--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com




More information about the AccessD mailing list