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

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
>