ODBC with Access 2

From: Dan Osterhout 
Subject: Re: ODBC Drivers For Access 2.0

> Eric.Shaw@barclays.co.uk wrote:
> 
> : We are currently upgrading our MS-Access systems to Access 2.0 and have a
> : requirement to link into Ingres 6.4 Databases.
> 
> : Does anyone have any information on (Good/Reliable :-)) ODBC software to
> : Link MS-ACCESS 2.0 to Ingres 6.4.
> 
> You can always start with the ODBC driver supplied with Ingres/NET. Feel
> free to email me if you need any further help.

We ran into some problems using MS Access 2.0 with Ingres 6.4. Ingres is
supposedly not certified to work with MS Access 2.0 yet.  One of the biggest
problems we came across is if you have a large table with a multi-column
primary key, you will get an ODBC-call failed when trying to read the table.
You may be able to edit/retrieve one record at a time, but won't be able
to scroll through the records.  The only way around this is to eliminate 
multi-column primary keys or use the SnapshotOnly=1 parameter in the
MSACC20.INI file (which willl cause the table to be read only).

For more information, I can be reached by e-mail at doster01@aol.com.
Ingres Q & A
To William's Home Page
Email William