Access to MS Access 97 in D2

Simon Scheure

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Access to MS Access 97 in D2

I know how to get access to one single Access 97 Database. My problem
is, that i have to write a browser to move through Access 97 Databases.
Is it possible to change the name of the connected Access 97 database on
runtime? Is it possible to define an ODBC-DNS and the Aliases out Delphi
2 also in runtime?
I heard, D3 supports MS Access 97 native. Does that mean, that one
doesn't have to use the ODBC-drivers anymore? Is this only a feature of
the professional version, or does D3 Standard also support MS Access
natively?
It's the first time I post a message in a newsgroup, so I hope I didn't
ask things that were asked many times already.
Thank's Simon

John Provin

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Access to MS Access 97 in D2

You can change databases at runtime. Close the database, then use the
"Params" array of the TDatabase and set the one for "ODBC DSN".

I don't believe you can create DSNs at runtime with Delphi without writing
to the ODBC API directly; use the "SQLConfigDatasource" function.

D3 doesn't have native support for Access97; Access95 only at the moment.

John

Simon Scheurer <Simon_Scheu...@hotmail.com> wrote in article
<33B24306.4...@hotmail.com>...

Quote

> I know how to get access to one single Access 97 Database. My problem
> is, that i have to write a browser to move through Access 97 Databases.
> Is it possible to change the name of the connected Access 97 database on
> runtime? Is it possible to define an ODBC-DNS and the Aliases out Delphi
> 2 also in runtime?
> I heard, D3 supports MS Access 97 native. Does that mean, that one
> doesn't have to use the ODBC-drivers anymore? Is this only a feature of
> the professional version, or does D3 Standard also support MS Access
> natively?
> It's the first time I post a message in a newsgroup, so I hope I didn't
> ask things that were asked many times already.
> Thank's Simon

Darin Cummin

Delphi Developer

Wed, 18 Jun 1902 08:00:00 GMT

Re:Access to MS Access 97 in D2

Simon Scheurer <Simon_Scheu...@hotmail.com> wrote in article
<33B24306.4...@hotmail.com>...

Quote

> I know how to get access to one single Access 97 Database. My problem
> is, that i have to write a browser to move through Access 97 Databases.
> Is it possible to change the name of the connected Access 97 database on
> runtime? Is it possible to define an ODBC-DNS and the Aliases out Delphi
> 2 also in runtime?
> I heard, D3 supports MS Access 97 native. Does that mean, that one
> doesn't have to use the ODBC-drivers anymore? Is this only a feature of
> the professional version, or does D3 Standard also support MS Access
> natively?
> It's the first time I post a message in a newsgroup, so I hope I didn't
> ask things that were asked many times already.
> Thank's Simon

Delpi3 does claim to dupport Access without ODBC. Delphi3, in fact, does
set up the hierarchy for the dataset component differently in D3, allowing
almost any DB to be accessed without ODBC if you want to inherit the object
and make the calls yourself.

Unfortunately, the Access access is not as flamboyant as Borland would like
to claim. They still have a lot of work to do.

Other Threads

1. D5-ADO-MS ACCESS 97 database-MS Office 97 Access ODBC driver-Autoincrement probs

2. Use MS ACCESS 97 BDE drivers for MS ACCESS 2000

3. Native MS Access 97 connection when MS Access 2K is installed on PC

4. Delphi 4 + Native Ms Access 97 driver + MS Access queries

5. D4 - MS Access 97 - MDAC 2.* TTable Access violations

6. Accessing MS Access 97 data from Delphi 3

7. Problem with MS Access 97 database, accessed by group of users

8. D2: Creation/Access to MS ACCESS Database

9. Build Index for MS Access 97 Table

10. Delphi 5 and MS Access 97 passing of Strings