Tom schreef:
> I have an application dating back to 1996.  I used DAO 2.5 for access to a
> Jet db.  Over time I migrated to DAO 2.5/3.51 and to VB6.  I use the Wise
> InstallBuilder 8 to create the install file.

I assume you are accessing an MS-Access database. For filesystem
databases (such as MS-Access), DAO is preferrable. You can access all
the tables and queries directly, without the overhead of emulating a
database server. Alas, Microsoft wants everybody to switch software
daily, and thinks it is old.
ADO is specially written for database servers (SQL server, oracle,
etc.), so for a database server you might as well use ADO. Alas,
Microsoft wants everybody to switch software daily, and thinks it is
old. (Hey, didn't I write that before?)
ADO dot NET is like ADO, but off course different, for the dot NET
framework. Better switch today if you like Microsoft upgrade schemes...

> Lately, people with Windows XP are not able to access the db.  I assume
> there are files missing.  I could probably figure out what's missing and
> include them in the install, but I think it's time to upgrade the db access.
> 
> I'm no longer actively involved in mainstream programming except for this
> one application, so I'm not up to date on the latest techniques.
> 
> Is DAO still viable?  Should I migrate to DAO 3.6, or is there a better
> access method these days.  Since I have to do the work, I'd like to do it
> the best way possible, but I'd also rather not do a major re-write of the
> application.
> 
If you create an installer, DAO (or ADO, for that matter) should be in
the install file. ADO has had some install problems in the past as well.
If you are afraid your database passwords get cracked (really simple in
DAO 3.51 generated databases), switch to DAO 3.6. Otherwise, I don't
know the difference. Note that DAO 3.6 generated database files are not
necessarily readable by DAO 3.51. The other way around should work fine.

I know Microsoft wanted to stop support for DAO. And, in the meantime,
probably have.

I have never worked with the "wise" program, and I never write
installers myself. Can't help you there, I'm afraid.

Good luck!
---
þ RIMEGate(tm)/RGXPost V1.14 at BBSWORLD * Info{at}bbsworld.com

---
 * RIMEGate(tm)V10.2áÿ* RelayNet(tm) NNTP Gateway * MoonDog BBS
 * RgateImp.MoonDog.BBS at 1/4/05 10:37:03 AM