• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 304
  • Last Modified:

connect to an access97 mdb

I want to connect to an access97 mdb.
My folder with mdb is c:\acce97
I dont know the steps to do so.
(delphi 4.0)
0
vage78
Asked:
vage78
1 Solution
 
intheCommented:
hi
the easiest way by far is to use diamond acess comps:
http://www.islamov.com/diamond/
no need for bde etc with them ..
Regards Barry
0
 
Phoenix_sCommented:
Open your BDE administrator

Create a new database entry of type MSACCESS

point it to the access MDB you want to connect to

use the alias name you created from within delphi to access the database and tables within.

read the manual on the BDE might help too ;)

cheers!
0
 
dejohn99Commented:
What version of Delphi are you using?

  Version 3.x BDE has problems with sort order.  Use a DAO object and a TClientDataset.  This seems to be the fastest access path we've found

  Version 4.x and 5.x seem to be okay with Access.

Ensure that you have version 3.5 of the jet engine installed.
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.

 
kifahCommented:
Step1: Run the BDE Administrator.
Step2: Right Click on the 'Database'.
Step3: Select New from the popup menu.
Step4: Select MSAccess from the Database driver name combobox.
Step5: Define the Database Name.

Pingo it is done.

Kifah R. Najem
0
 
intheCommented:
didnt someone else write that already ?? ...
0
 
RadlerCommented:
To Delphi 5 the ADO is availble to direct use.

T++, Radler.
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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now