Solved

MDB and Delphi

Posted on 1998-05-11
6
457 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
  • 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How to convert wav to mp3 in delphi 9 219
FMX enumerated colours 2 115
Why can't I create any project with my delphi EXE file? 6 39
Tidtcpserver listening on multiports? 1 35
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

790 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