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

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
0
AndersWP
Asked:
AndersWP
1 Solution
 
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
 
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
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

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.

 
spokraevCommented:
1. Set the Driver name property to MSACCESS
2. Set Parameter DATABASE NAME=DRIVE:/PATH/DATABASE.MDB
0
 
AndersWPAuthor Commented:
Right on the button!

Thanks,
AndersWP
0
 
lortegaCommented:
Invalid Alias Name error !

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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