Solved

MDB and Delphi

Posted on 1998-05-11
6
460 Views
Last Modified: 2010-04-06
How could I work with MDB databases in Delphi 2.

What about Delphi 3?
0
Comment
Question by:bor061297
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
6 Comments
 
LVL 5

Expert Comment

by:JimBob091197
ID: 1344449
Hi

You can use Access 95 & 97 databases with Delphi 3.  (I haven't tried with Delphi 2.)  The Borland Database Engine (BDE) connects natively to Access.  (For Access 97 you will need to get the latest version of the BDE from Borland's (Inprise) web site.)  You create an alias with the BDE admin, and connect as with Paradox tables.

Cheers,
JB
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1344450
If you have the Client/Server version you can connect natively.
If you don't have the C/S then you can connect only via ODBC.
0
 
LVL 5

Expert Comment

by:JimBob091197
ID: 1344451
Ronit:  I have Delphi Professional which also supports connections to Access through the BDE (which uses DAO, not ODBC).

Cheers,
JB
0
Industry Leaders: 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!

 
LVL 5

Expert Comment

by:JimBob091197
ID: 1344452
(Above should read "Delphi 3 Pro"...)
0
 
LVL 5

Expert Comment

by:ronit051397
ID: 1344453
0
 

Accepted Solution

by:
lucab earned 50 total points
ID: 1344454
You can use ODBC towards Access 95 & 97 from Delphi 2.0
and the same + DAO (native access) from Delphi 3.0.

Be very careful because you'll find differences between the two.

0

Featured Post

Industry Leaders: 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

In this tutorial I will show you how to use the Windows Speech API in Delphi. I will only cover basic functions such as text to speech and controlling the speed of the speech. SAPI Installation First you need to install the SAPI type library, th…
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Finding and deleting duplicate (picture) files can be a time consuming task. My wife and I, our three kids and their families all share one dilemma: Managing our pictures. Between desktops, laptops, phones, tablets, and cameras; over the last decade…

738 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