Reading MS-Access database w/ delphi 
Author Message
 Reading MS-Access database w/ delphi

Hi everybody!

I have an application that I developed in MS-access.
I'd like to move into delphi - but cannot just "dump" ms-access, since
I already have users with data (lots of it...) in an Access database.

Is there a way to leave the .MDB file (Access databse file) and
somehow "tell" Delphi to use it?

Don't just say "ODBC" - since I really don't know much about it (like
- do I have to have Access running in order to read/write data to an
MDB file?) - please elaborate as much as u can...

        10x a lot!

PS: I don't mind writing the interface again - I just need a way to
read/write data...



Tue, 10 Mar 1998 03:00:00 GMT  
 Reading MS-Access database w/ delphi

Quote:

>I have an application that I developed in MS-access.
>I'd like to move into Delphi - but cannot just "dump" ms-access, since
>I already have users with data (lots of it...) in an Access database.
>Is there a way to leave the .MDB file (Access databse file) and
>somehow "tell" Delphi to use it?
>Don't just say "ODBC" - since I really don't know much about it (like
>- do I have to have Access running in order to read/write data to an
>MDB file?) - please elaborate as much as u can...

ODBC.

The Borland Database Engine (BDE), which is the primary data engine bundled
with Delphi, does not have the capability to provide native access (pardon
the pun) to MS Access databases. Microsoft has not released the Access
database specification for licensed third-party use. What remains is
accessing these databases through an additional layer: the ODBC driver.

Accessing databases not natively supported by Delphi/BDE is relatively
painless (with some exceptions). The ODBC driver is available from
Microsoft (I believe for about US$10). It is configured using the ODBC
Manager applet in Control Panel. Once configured (and a Data Source Name,
or DSN, is created in the process) the DSN can be added to the BDE
configuration. Once all of this is accomplished, access to these databases
from within Delphi applications is transparent and virtually the same as
for natively supported table type (again with a few exceptions, mostly to
do with differing field/column types or limitations in ODBC drivers).

Borland offers a TI (Technical Information sheet) describing this process:
TI2781, "Step By Step Configuration Of An ODBC Driver."

**************************************************************************
Steve Koterski
Local InterBase Server Technical Support
Borland International, Inc.



Fri, 13 Mar 1998 03:00:00 GMT  
 Reading MS-Access database w/ delphi

Quote:
> Hi everybody!

> I have an application that I developed in MS-access.
> I'd like to move into Delphi - but cannot just "dump" ms-access, since
> I already have users with data (lots of it...) in an Access database.

> Is there a way to leave the .MDB file (Access databse file) and
> somehow "tell" Delphi to use it?

> Don't just say "ODBC" - since I really don't know much about it (like
> - do I have to have Access running in order to read/write data to an
> MDB file?) - please elaborate as much as u can...

>    10x a lot!

> PS: I don't mind writing the interface again - I just need a way to
> read/write data...

Well, thanx for asking. I was wondering how to do that too. Can somebody
give us a clue or maybe be more specific about it. Thank you.

Vladi.



Mon, 16 Mar 1998 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Reading MS-Access-2-Database from Delphi 1 via ODBC

2. Accessing a MS Access Database with Delphi 4

3. Accessing MS Access database with Delphi application

4. Accessing MS Access database with Delphi application

5. Read/Update MS Access 7.0 db from Delphi Developer 2.0 (PLEASE HELP)

6. Deploying delphi app with MS Access database

7. Deleting a detail record using Delphi 1.0 on a MS Access 2.0 database

8. Delphi & MS Access database(multi-user)

9. How to use a MS-Access-Database with Delphi 4

10. Opening database (developed by Delphi) in MS Access

11. Reports in Delphi 4 with native MS Access Database

12. Ms Access database versus specialised one written in Delphi

 

 
Powered by phpBB® Forum Software