Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Connect to an Access MDB without using BDE?

Posted on 2009-04-02
3
Medium Priority
?
591 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 500 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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Whether it be Exchange Server Crash Issues, Dirty Shutdown Errors or Failed to mount error, Stellar Phoenix Mailbox Exchange Recovery has always got your back. With the help of its easy to understand user interface and 3 simple steps recovery proced…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…
Suggested Courses
Course of the Month12 days, 5 hours left to enroll

564 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