Delphi 2.0 and MS Access 7.0

rspi...@ghgcorp.com (Roy)

Delphi Developer

Thu, 10 Dec 1998 03:00:00 GMT

Delphi 2.0 and MS Access 7.0

I have had extreme problems trying to get Delphi 2.0 to work with
Access7.0. The BDE interface does not seem to work and the components
give errors when used with Access 7.0. Has anyone else had these
problems or just me? Is there a fix out there?

Bryan Kelle

Delphi Developer

Thu, 10 Dec 1998 03:00:00 GMT

Re:Delphi 2.0 and MS Access 7.0

Quote

Roy wrote:

> I have had extreme problems trying to get Delphi 2.0 to work with
> Access7.0. The BDE interface does not seem to work and the components
> give errors when used with Access 7.0. Has anyone else had these
> problems or just me? Is there a fix out there?

What kind of errors? It takes some tweaking to get ODBC Access to work
properly. You may want to check out Opus DirectAccess
( http://www/opus/ch ) which is a product that uses the DAO rather than
ODBC to access Access tables. I've been playing with it quite a bit, and
it is much nicer than ODBC.

-Bryan

Bryan Kelle

Delphi Developer

Thu, 10 Dec 1998 03:00:00 GMT

Re:Delphi 2.0 and MS Access 7.0

Oops, sorry, the site is http://www.opus.ch

-Bryan

Robert Griffit

Delphi Developer

Sat, 12 Dec 1998 03:00:00 GMT

Re:Delphi 2.0 and MS Access 7.0

In article <4qimq9$...@news.ghgcorp.com>, rspi...@ghgcorp.com says...

Quote

>I have had extreme problems trying to get Delphi 2.0 to work with
>Access7.0. The BDE interface does not seem to work and the components
>give errors when used with Access 7.0. Has anyone else had these
>problems or just me? Is there a fix out there?

This has been on the forum a few times. Yet the ODBC driver is very
buggy. There is an updated driver pack that can be downloaded from
MS. However this didn't help me much at all.

I have decided to use the DAO (OLE) interface to the Jet engine, this
works very well. But you loose out on data aware controls etc. If you
need more info on this let me know, or search via dejanews or some such
for earlier postings.

Robert Griffiths (vis...@iinet.net.au)

Mike Wils

Delphi Developer

Mon, 14 Dec 1998 03:00:00 GMT

Re:Delphi 2.0 and MS Access 7.0

I have Delphi 2 talking to Access 7 and it works pretty well, if
a little slowly. I have put example configurations with
screen-shots of the config dialogs on my Web pages -- follow the
link to 'BDE Solutions' on my home page (URL below).

Regards,

--------------------------------------------------------------------
Mike Wilson m...@oasis.icl.co.uk
SNI Medical Portfolio, 9-15 Blagrave Street, Reading, RG1 1PJ, UK
At home: m...@plexus.demon.co.uk http://www.hway.com/mrw

Other Threads

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

2. Access 7.0 -> Delphi 2.0 access

3. Delphi 2.0 and MS Access 2.0

4. Delphi 2.0 - Access 7.0 - sql statements

5. Access 7.0 and Delphi 2.0 Query Error

6. Access 7.0 and Delphi 2.0 Client/Server

7. Accessing Access 2.0 MDBs from Delphi 2.0

8. Db.StartTransaction in Delphi 2.01 using MS Access 7.0 ODBC Driver fails

9. MSSQL 7.0, Delphi 4, MS Access

10. DELPHI 2.0 AND MS ACCESS