Interfacing Oracle and ms Access [message #64637] |
Thu, 17 February 2005 00:49 |
Bug Jargal
Messages: 1 Registered: February 2005
|
Junior Member |
|
|
Hi all ;)
I've got users that are accessing an oracle (9.2.0.5) database through linked tables in Access (2000 and 2003). MS application is connected through an ODBC link (9.2.0.6.2).
My problem:
All was working well until we created new tables in a separated tablespace. Since then, these users can browse these tables, but they can not insert, update records.
On my side, using the same oracle user to login. I can do anything from my access installation (2003) on the same tables.
Any idea where the problem could be ?
Thanks in advance for any clue or answer...
|
|
|