Article View: comp.lang.pascal.delphi.databases
Article #107Re: Accessing MS Access 97 data from Delphi 3
From: Ray Porter
Date: Mon, 13 Apr 1998 00:00
Date: Mon, 13 Apr 1998 00:00
36 lines
2273 bytes
2273 bytes
Start the BDE Administrator. On the Configuration/Drivers Tab in the BDEAdmin, make sure the dll
name for the MSACCESS native driver is IDDA3532.DLL (just select it from the drop-down, the other
choice, IDAO3032.DLL, is for Access 95). Create an alias that points to your Access 97 .mdb
file. Drop a TDatabase and a TTable or TQuery on your form or your TDataModule. Point the
TDatabase to the alias you just created and set the login prompt to false (unless you have
security turned on for the Access database). Connect your TTable or TQuery component to your
TDatabase and you're ready to go. BTW, you don't absolutely need the TDatabase. It is just there
to surpress the Access userid/password dialog that will normally be displayed.
Thomas Krogsgaard Pedersen wrote:
> I wish to use an access database as a source of data for delphi 3.
> I have BDE version 4.51, but my experience with this product is nonexisting.
>
> What I am looking for is a simple example (as simple as possible) explaining how to connect an
> application to the database. I do not wish to use ODBC.
>
> I am currently unable to access anything...
>
> Thomas K
--
================================================
Ray Porter
Applications Analyst Programmer
Administrative Information Services, UNC-CH
Phone: 966-5878
email: lrp@email.adp.unc.edu
dragon@email.unc.edu
Home Page: http://www.adp.unc.edu/~allrp/
"Meddle not in the affairs of dragons,
for you are crunchy and taste good with ketchup."
Technical Details
Message-ID:
<3531F879.4E3364BA@email.adp.unc.edu>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<352B445C.643146F@netkompagniet.dk>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ffff5,e99b247e0f4f865d X-Google-Attributes: gidffff5,public X-Google-Thread: ff75c,e99b247e0f4f865d X-Google-Attributes: gidff75c,public From: Ray Porter <lrp@email.adp.unc.edu> Subject: Re: Accessing MS Access 97 data from Delphi 3 Date: 1998/04/13 Message-ID: <3531F879.4E3364BA@email.adp.unc.edu> X-Deja-AN: 343569248 Content-Transfer-Encoding: 7bit References: <352B445C.643146F@netkompagniet.dk> Mime-Version: 1.0 To: Thomas Krogsgaard Pedersen <thomas@netkompagniet.dk> Content-Type: text/plain; charset=us-ascii Organization: The University of North Carolina at Chapel Hill Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database.desktop