Connect to an Access MDB without using BDE?

You have two other choices:

- Direct ODBC
- ADO

If the version of Delphi that you are using has the AdoExpress components then you are all set. Even if it does not, you can still import the type library information from msado15.dll which will give you the automation interface wrappers into ADO (and thus allow you to get the jet mdb). The other alterntive, and probably at a level you don't want to deal with, is by using direct ODBC SQLxxxx calls.

Your best bet is to figure out if you have the component wrappers for ADO in your version of Delphi. If you do, then check the help files for info regarding props/methods. If you don't, then import the ADO type library info and check the MSDN online for examples using ADO. Its fairly simple to use, and there are a number of resources on line for help.

Regards,
Russell

>> If the version of Delphi that you are using has the AdoExpress components then you are all set

I am looking at my Delphi 7 component bar, and I only see "ADO", not "AdoExpress".

When I look at my Delphi 2005 component list, I see a dbGo group with some ADO components.

I also have heard that using DAO is more efficient than ADO.  True?