Until now (using Delphi 4, client server suite) it was absolutely no
problem to access MS-Access-databases (Access 97) using
BDE-native-drivers. But now with Delphi 5 (professional) I encountered
the following problem: I created a entry in the BDE-administrator and
set the location of the database (drive, path, filename). Then I
inserted a TDatabase-component in the delphi environment on my form and
used the BDE-entry-name as Alias-property of the TDatabase-component. As
Databasename-Property and Name-Property I used for example "DBLocal".
Trying to set the Connected-Property of the TDatabase-component to
"true" leads to an "General SQL error ...".

Who has encountered the same problems or who can tell me what mistakes
do I make? I would be very glad if you could give me a hint or even a
solution.

please mail your answers "mgschus...@hotmail.com"

best regards
matthias

First of all, I never create an alias to use Access. This is just a
preference and in no way suggests that it is the best way. However, it makes
my life easier to just put any parameters I need in the TDatabase component.
The only parameter I ever really "needed" to put there was the Database
Name=path/databasename. Everything else can default unless you write
programs for different versions of Access. Then you can use the DLL32= to
set the right DAO DLL for the version you use.

Sorry if this doesn't help you, it just seems to make installations a lot
easier when you don't have to worry about setting up aliases on end user
machines.

--

Woody

news:38A2B8C9.7B4B61CD@finance.bwl.univie.ac.at...
Until now (using Delphi 4, client server suite) it was absolutely no
problem to access MS-Access-databases (Access 97) using
BDE-native-drivers. But now with Delphi 5 (professional) I encountered
the following problem: I created a entry in the BDE-administrator and
set the location of the database (drive, path, filename). Then I
inserted a TDatabase-component in the delphi environment on my form and
used the BDE-entry-name as Alias-property of the TDatabase-component. As
Databasename-Property and Name-Property I used for example "DBLocal".
Trying to set the Connected-Property of the TDatabase-component to
"true" leads to an "General SQL error ...".

Who has encountered the same problems or who can tell me what mistakes
do I make? I would be very glad if you could give me a hint or even a
solution.

please mail your answers "mgschus...@hotmail.com"

best regards
matthias