Using Access 97 without a BDE alias

In Delphi you can access a Paradox database without using a BDE alias by setting the database object property 'DriverName' to 'standard' and setting the current directory to the directory that contains the Paradox table files.

Is there a way of doing something similar with an Access 97 datbase, i.e. accessing it through the BDE driver but without using a BDE alias?

Thanks in advance,
AndersWP
LVL 1
AndersWPAsked:
Who is Participating?
 
spokraevConnect With a Mentor Commented:
1. Set the Driver name property to MSACCESS
2. Set Parameter DATABASE NAME=DRIVE:/PATH/DATABASE.MDB
0
 
ronit051397Commented:
Why you don't want to use BDE Alias?
0
 
AndersWPAuthor Commented:
Because I have to distribute my application to a large number of PC's, and I would prefer to have as little bother as possible with the BDE configuration.

AndersWP
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
ronit051397Commented:
I don't know the answer, but it takes 2 lines to add an alias to the BDE, here is an example for adding an Alias named 'Sample' for Informix:

Check(dbiInit(Nil));
Check((DbiAddAlias(Nil, 'Sample', 'INFORMIX', 'DATABASE NAME:SampleDB;' +
            'SERVER NAME:ol_ronit;' + 'USER NAME:informix;', True)));

for Access you will have to set other parameters, see BDE docs.
0
 
AndersWPAuthor Commented:
Right on the button!

Thanks,
AndersWP
0
 
lortegaCommented:
Invalid Alias Name error !

0
All Courses

From novice to tech pro — start learning today.