Oracle linked tables

M

Mark

Sorry this is basic....
I have a Access mdb that has linked (ODBC) Oracle tables. Tables that are
not indexed with a PK are read only. Am I right in that in order to update a
linked Oracle db there must be a PK field?
Thanks for you help,
Mark
 
M

Mark

I’ve found reference to adding a time stamp field to ODBC linked tables. Is
this necessary and why?
M
 
J

John W. Vinson

I’ve found reference to adding a time stamp field to ODBC linked tables. Is
this necessary and why?

It's helpful with a SQL/Server backend. The (rather oddly named, since it has
no time content) Timestamp field type is used to detect that a record has
changed. I don't know if there is a comprable fieldtype in Oracle but I would
guess that there is not.
 

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

Top