Solved

Using Access 97 without a BDE alias

Posted on 1998-06-08
6
316 Views
Last Modified: 2010-04-04
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
Comment
Question by:AndersWP
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 5

Expert Comment

by:ronit051397
ID: 1351348
Why you don't want to use BDE Alias?
0
 
LVL 1

Author Comment

by:AndersWP
ID: 1351349
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
 
LVL 5

Expert Comment

by:ronit051397
ID: 1351350
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Accepted Solution

by:
spokraev earned 100 total points
ID: 1351351
1. Set the Driver name property to MSACCESS
2. Set Parameter DATABASE NAME=DRIVE:/PATH/DATABASE.MDB
0
 
LVL 1

Author Comment

by:AndersWP
ID: 1351352
Right on the button!

Thanks,
AndersWP
0
 
LVL 2

Expert Comment

by:lortega
ID: 1351353
Invalid Alias Name error !

0

Featured Post

[Webinar] Code, Load, and Grow

Managing multiple websites, servers, applications, and security on a daily basis? Join us for a webinar on May 25th to learn how to simplify administration and management of virtual hosts for IT admins, create a secure environment, and deploy code more effectively and frequently.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Connection between libmysql.dll and MySQL Versions 7 132
LAN or WAN ? 11 120
Firemonkey webbrowser scrollbars ? 1 70
Not able to call Delphi XE10 dll function from Delphi 6.0 4 56
A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question