Link to home
Start Free TrialLog in
Avatar of AndersWP
AndersWP

asked on

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
Avatar of ronit051397
ronit051397

Why you don't want to use BDE Alias?
Avatar of AndersWP

ASKER

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
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.
ASKER CERTIFIED SOLUTION
Avatar of spokraev
spokraev

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Right on the button!

Thanks,
AndersWP
Invalid Alias Name error !