If you want to link to a Microsoft Access database from a standalone VB program, you can use ADODB. The connection string will need to be specific for Access. I'm looking for a sample and will post it when I find it.
You can also set up an ODBC connection for the MS Access database and use that in your VB for connecting.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
There is no need to us ADODB to link to an Access MDB or ACCDB.
<There is no need to us ADODB to link to an Access MDB or ACCDB.>
If you mean to link tables then you're right - DAO is much easier to work with if the goal is to build linked tables from within Access.
If the OP wishes to connect to an Access database from another environment (like VB or ASP) there's nothing wrong with using ADO. In many cases it's preferable to build a connection to the Database using ADO and then work with that connection, depending on what you want to accomplish.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Has this question been resolved? Can we close the question ?
thx.mx
Guy Hengel [angelIII / a3]
I've requested that this question be deleted for the following reason:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.