Solved

Connect to an Access MDB without using BDE?

Posted on 2009-04-02
3
551 Views
Last Modified: 2013-11-23
Is it possible to connect to a Microsoft Access MDB file without using the Borland Database Engine?  If 'yes,' then how?
0
Comment
Question by:Monroe406
  • 2
3 Comments
 
LVL 26

Expert Comment

by:Russell Libby
ID: 24056192
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
0
 

Author Comment

by:Monroe406
ID: 24056286
>> 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?
0
 
LVL 26

Accepted Solution

by:
Russell Libby earned 125 total points
ID: 24056489

If you have an ADO component group, then you have"AdoExpress" installed which is what provides the components. (AdoExpress - Borland's terminology for the component wrappers they wrote which encapsulate the ADO COM interfaces by way of components).

As to DAO, that might have been true 10 years ago, but I would be hard put to believe it nowadays without evidence. DAO is antiquated, and moreover I'm not sure if its still even supported. Jet has a native OLEDB driver, which can be accessed via ADO (ADO is simplified wrapper over OLEDB). If you use the TAdoConnection and related components, you will find that you can access your mdb in the same fashion as you might have with the BDE, sans the BDE.

Russell
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Virtuailstring tree add node to another virtuailstring tree list 4 115
add combobox item based on numbers 9 141
oracle global variables 4 68
Twebbrowser add css to the header 3 24
This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

806 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question