Re: Access/VB <-ODBC->Oracle

We were trying to use Access to load our Oracle databases and have been running into all kinds of trouble. We run SCT's Banner software for our front end. I check Microsoft's KB and there are a load of bugs and problems when mixing Oracle and Access together.

Loy&Hutz wrote:
>
> Please help me !!!
>
> I want to know, if you NOT have this problems:
>
> (VB / Access 2.0/97)
>
> 1. Select an oracle row in VB / Access where one or more Date-Time columns
> are NULL (I get error -7764 ODBC specification error)
>
> 2. Include Oracle tabs with more than 36 columns in access or link to with
> vb. I get then alway the same wrong column order
>
> 3. Update / Delete rows in Access (Table view) or in VB with
> Update/Delete-method causes "data has changed by another user, operation
> stopped" when a column is NULL
>
> If yes, please tell me, which version you use.
>
> I´m getting crazy with my migration project from Access-DB to Oracle,
> because of all this ugly behaviour.
>
> Any help is welcome !
Received on Fri Mar 27 1998 - 00:00:00 CST