Access and Oracle ODBC

From: Jerome Tytgat <sea_at_gaz-de-strasbourg.fr>
Date: Thu, 30 Sep 1999 14:12:15 +0200
Message-ID: <7svjvc$krl$1@jaydee.iway.fr>

hello,

I have a big problem with a access database migration under Oracle Tables.

I'm using the driver "Oracle ODBC fro Oracle 7.3.4" to attach Oracle table under an Access 97, and we use Access 97 to requery informations on these tables. But :

1- Sometimes, even if we r already connected, the driver ask for a reconnection (only on some few tables, NOT ALL) 2- Sometimes it ask it in loop... when i want to open a specific table (sometimes not...) and write #error in each fields. 3- Sometimes even if we can open the tables with no problem et we want to make a requery on it, it send back an error ODBC : 00960 (duplicate name field, but THERE'S NO DUPLICATE NAME FIELDS ! :( ) 4- I have just to suppress the attachment and reattach the table and all is fine !!!! But that's bad for the users !

Ok, if someone know anything about this, please Help ME...

Thanks. Received on Thu Sep 30 1999 - 07:12:15 CDT