> So my question is can the set up of a local ODBC be done in some
> kind of script perhaps with the Access Developers tool kit? It
> appears when I set up my local ODBC some entries are made to a
> file called ODBC.ini in the registry. Can this be automated in
> the developers tool kit?. I don't want to have to guide 100+ users
> through the ODBC setup process. Can Access utilize an ADO connection?
I do some work on a project where Informix is accessed via ODBC from
Access 2, using InterSolv's ODBC drivers. The users all have Access 2
installed, so no runtime is distributed, but there are some third-party
libraries, as well. They (nota bene: I did not do the packaging) use
Wise InstallMaster to package the installation which can be downloaded
or transported on a CD and will install all the needed software,
including the ODBC drivers.
Access 97 can utilize ADO if you use unbound forms, retrieve your
information via code, and duplicate many functions that Access provides
for you with bound forms. Access 2000 can utilize ADO, provided all you
want are the features that actually are available, which are not nearly
all that should be. But you'd be well advised to wait to see what
issues are resolved by the rumored Service Release 1 before jumping
feet first into that tar pit. Why do you ask? Do you think it would be
simpler to lead all those users through installing the MDAC 2.x than it
would be to lead them through installing ODBC?
L. M. (Larry) Linson
Access example databases at http://homestead.deja.com/user.accdevel
New: Book reviews, previously published in North Texas PC News
Script execution must be enabled and Windows set to Small Fonts
Sent via Deja.com http://www.deja.com/
Before you buy.