
ADO with MDAC 2.5 and Jet Dependency?
Any help appreciated.
I have a VB app that uses a Access 2000 database. However, now that MDAC 2.6
no longer contains Jet, I am thinking of switching to something else. I
have three questions:
1) Does ADO need Jet to work? ( I'm thinking no)
2) Is there any other simple data format that ADO can access where MDAC on
the machine is enough? Meaning, I distribute my app with MDAC 2.6 and some
other data format instead of Access.
a) What is the DTAFlatFile provider
b) What is the Simple Provider
c) Any other providers that all is need is MDAC
3) What about this idea. Distribute my data in a simple 25,000 record 6
field comma delimitated format. Then create a ADO recordset on the fly (by
appending fields in code). Then loop through the comma delimitated file
adding records to the ADO recordset? I will do a test app to try I guess
and see how it effects performance.
As always, us novices appreciated any guidance from the masters.
Thanks,
DJ