#Deleted with linked Oracle table

G

Guest

WinXP/Access 2003 - when links to an Oracle table, every row displays
#Deleted. When looking at the data through SQL - the data is visible. If the
table is imported into Access the data is visible. It is only when the table
is linked that the errors appear. Oracle 10g driver. The primary keys are all
nchar(36) or nchar(30). The client has been able to link to these tables
successfully before. As far as he knows - nothing has changed.

maryj
 
A

aaron.kempf

MDB is _CRAP_
Oracle is _CRAP_

use sql server and access data projects; it is the best interface; the
best IDE; the best software development platform ANYWHERE IN THE WORLD

MDB is for babies.

if your company bought oracle that means that they're SUCKERS

oracle sucks balls

use SQL Server.. Access Data Projects

MDB isn't realible enough for anything.
and i haven't found anything else reliable on the market.

Use Access Data Projects and linked servers... it's just as powerful
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Table Issue to Oracle 1
"#deleted" values in linked (ODBC) Oracle tables 3
Embed Username & Password in Oracle External Linked Table 1
Access 2003 not linked to Oracle 11g 3
Oracle linked tables 3
Linked Oracle table is repeating data, why? 1
Linking Access and Oracle problem 4
Export an Access table to an EXISTING Oracle Table 1

Top