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)
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

the easiest way by far is to use diamond acess comps:
no need for bde etc with them ..
Regards Barry
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 ;)

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.
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
didnt someone else write that already ?? ...
To Delphi 5 the ADO is availble to direct use.

T++, Radler.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.