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)
My folder with mdb is c:\acce97
I dont know the steps to do so.
(delphi 4.0)
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!
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!
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
didnt someone else write that already ?? ...
To Delphi 5 the ADO is availble to direct use.
T++, Radler.
T++, Radler.
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