Accessing Microsoft Access from Delphi

Accessing Microsoft Access from Delphi

Post by Ed Vanderho » Sun, 13 Aug 1995 04:00:00



I need to access Microsoft Access 2.0 tables from within Delphi
_without_ resorting to ODBC.  Does anyone know of any packages which
do this.  If all else fails, some documentation for the MS-Jet engine
would be appreciated.

TIA, Ed.

 
 
 

Accessing Microsoft Access from Delphi

Post by Ebbe Jonss » Mon, 14 Aug 1995 04:00:00


: I need to access Microsoft Access 2.0 tables from within Delphi
: _without_ resorting to ODBC.  Does anyone know of any packages which
: do this.  If all else fails, some documentation for the MS-Jet engine
: would be appreciated.

You cannot do that. Microsoft has not released any documentation
for a native Jet engine API, their position is 'use ODBC, or use
Visual Basic'.

--


Fax: +358 0 33 88 22                                    " Why me? "

 
 
 

Accessing Microsoft Access from Delphi

Post by Nick Shan » Tue, 15 Aug 1995 04:00:00


Quote:>>I need to access Microsoft Access 2.0 tables from within Delphi
>>_without_ resorting to ODBC.  Does anyone know of any packages which
>>do this.  If all else fails, some documentation for the MS-Jet engine
>>would be appreciated.

Cannot be done except via ODBC. There is no documentation for the Jet engine. Microsoft
will not release it.

Nick Shanny

 
 
 

1. Accessing Delphi (Paradox?) data using Microsoft Access 97

A year or so ago we hired a consultant to write custom reports for a Delphi
app. that we have.  He chose to do this in Microsoft Access 97 because a) we
already had it; and b) the report writer built into the Delphi app. didn't
have all the features he needed. This worked great.  Unfortunately, we're
uprading to the new version of the application, which now uses Delphi 4 and
is compiled for 32-bit (it was 16-bit previously).  I'm not sure what the
difference in database formats is, but it seems that MS Access 97 can no
longer open updated tables (the message is: "External table isn't in the
expected format.").

I called the company that makes the Delphi program, and they're not sure
what format the data files are in.  They used something called SQL Explorer
(which apparently comes with Delphi?) to look at the table, and here is some
relevant information it reports:

table type: paradox 5.0 clustered
version: 72
structure: blank

The developers aren't really sure what the "table type" or the "version"
fields represent, so they're not exactly sure what I should be using to open
the Delphi tables.  I'm currently using Access 97 on Windows 2000 (we'll try
Access 2000 if we have to (we don't own a copy) but all or Access databases
are in 97 so that will cause all kinds of issues) and accessing the tables
using the data access package that came with the valupack on the Access/MS
Office Pro CD.

Any suggestions?  I'll ask on a Microsoft forum, too, but this seemed more
appropriate since I can't even tell what version of Paradox I'm trying to
connect to!

Thanks!

Jen

2. Newbie: Createing duplicate DataBase unsing DTS Import

3. Delphi Components For Microsoft Access databases

4. Oracle Financials rel 10.7 GUI, GL, AP, FA, Reports, Contract

5. Delphi components for Microsoft Access

6. restoring a Solaris disk dump into Linux???

7. Delphi using Microsoft Access Data Base

8. Is there a FAQ for this group?

9. Delphi components for Microsoft Access

10. Microsoft Access Delphi Components

11. Creating and accessing a link to a Microsoft Access database

12. Does user need Microsoft Access License to use EXE file that access .MDB file

13. IBM Client Access and Microsoft Access 97 linked tables