[AccessD] Automatic import of tables, forms, rpts, mods

Thanks, William -   I'll try it!




On 8/6/07, William Hindman <wdhindman at dejpolsystems.com> wrote:
>
> Janet
>
> ...not quite sure what you are after here but lets try this instead
> ...create a separate fe mdb on your developer system ...put all of your
> functionality into it and version it ...then publish it to an udate folder
> on your website or the client's server ...if your fe mdb is versioned
> properly and you have auto update code installed, the user log-on sequence
> will check your update folder's fe mdb version against the installed one
> and
> replace the current installed version on the client if it is older than
> the
> one on the server.
>
> ...there are a number of auto update routines available ...I use the one
> from Allen Browne's site and have not had a problem with it yet.
>
> William Hindman
> ----- Original Message -----
> From: "Janet Erbach" <jerbach.access at gmail.com>
> To: "Access Developers discussion and problem solving"
> <accessD at databaseadvisors.com>
> Sent: Monday, August 06, 2007 12:22 PM
> Subject: [AccessD] Automatic import of tables, forms, rpts, mods
>
>
> > Hello.
> >
> > Does anyone have some tips for me on how to create an automated import
> > module for my database?  I've created some custom functions for it that
> > are
> > stored in a separate database from the main one, and everytime we
> upgrade
> > I
> > have to re-import the relevant tables, forms, rpts, etc. to each
> > workstation
> > where the application is installed.  I've linked tables into the
> back-end
> > database where appropriate, and those are re-linked automatically by the
> > main application itself.   But all my other custom objects are currently
> > imported 'by hand'.
> >
> > Today I created an 'import specs' table which contains the name of each
> > object I want to import automatically;  it also specifies the object
> type
> > (form, table, rpt, etc).  Is there some straightforward way to loop
> > through
> > each record in this table, delete the existing object if one with that
> > name
> > already exists in that workstation's app, and then import the most
> current
> > one from the database that storehouses all the customizations?
> >
> > I did a cursory search for a utility that might handle this for me, but
> > haven't found one thus far...
> >
> > Any suggestions will be appreciated!
> >
> > Janet Erbach
> > --
> > 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
>