[AccessD] Is there an easier way?

We're talking government employees here, from dozens of states.  They
have no interest whatsoever in helping me.  We are lucky to get the
lists at all.

John W. Colby 
www.ColbyConsulting.com

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Lavsa, Rich
Sent: Tuesday, June 01, 2004 12:00 PM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Is there an easier way?


I have done something like this, but on a smaller scale.  I have a
database that gets updated once a year by outside providers. I didn't
want to go through what you described below so I took the time to build
an "Update Database" that I sent out to all the companies that needed to
update information.  I leave it up to the companies to get the data into
the database the way they want it, then they send the "update database"
to me once a year.  This process is so simple that it is totally left up
to the users to decide when to update the database, so far its been a
"no brainer" push the button marked "UPDATE" which goes out to the
network location where the database expects it to be which will run all
the validation code to update and insert data.

I thought it was a good idea at first, and even better when I convinced
the companies to format their data for me so I wouldn't have to worry
about it. Sounds like a better approach for your purposes as well.  

Maybe feasible, maybe not.. 

G'luck
Rich