Is my concept workable?

13 May 2005 5:36 AM

Jim Richards

Hello. I have a small database (356 records) in Access 2000 and the same
database upsized to SQL Server 2000. They track who owns the lots in my
subdivision. The owner information is in a public database maintained by
Bexar County Appraisal District (BCAD). Using VB and VBA, is it possible to
create an application that programattically compares the data in my database
with the data in the BCAD database and where they do not match use the BCAD
data to update my database? Thanks in advance for any help. Jim.

13 May 2005 12:43 PM

Peter Aitken

"Jim Richards" <JWRicha***@satx.rr.com> wrote in message
news:j1Xge.70467$h6.22272@tornado.texas.rr.com...
> Hello. I have a small database (356 records) in Access 2000 and the same
> database upsized to SQL Server 2000. They track who owns the lots in my
> subdivision. The owner information is in a public database maintained by
> Bexar County Appraisal District (BCAD). Using VB and VBA, is it possible
> to create an application that programattically compares the data in my
> database with the data in the BCAD database and where they do not match
> use the BCAD data to update my database? Thanks in advance for any help.
> Jim.
>

Yes, that is certainly possible. The details will depend on how you are able
to access the BCAD database. Then it's a simple matter of looping through
the properties, comparing data, and updating as needed.

--
Peter Aitken

Remove the crap from my email address before using.