Solved

Using Access 97 without a BDE alias

Posted on 1998-06-08
6
310 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
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
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.

 

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

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Help on project with Soap 10 53
LAN or WAN ? 11 90
How to define IfThen functions in one common unit? 4 50
Dynamically Created Query 3 55
Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

786 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