Access Security with Oracle back end

[dd123]

I have a database in Oracle XE with an Access front end. It connects
successfully via ODBC without any problem. All the data is accessible but no
inserts or updates will work. I have created a new Workgroup Information File
with a default administrative user (as described in SECFAQ) which is the
default administrative user in the Oracle database and the user that logs in
through the ODBC. Even as the default user on both ends with full
administrative access, I cannot perform updates or inserts. The Insert New
Record is grayed out. I have even tried creating a new blank database and
copying the structure in to create a new security profile but still no change.
Other suggestions, please? Thanks!

 

[Douglas J. Steele]

I doubt very much that Access Security is to blame for this. Do you have a
unique index defined on each table in Oracle?

 

[dd123]

Yes. I went ahead and rebuilt them just to be sure. Would mapping a memo
field to a VARCHAR2(4000) create an update or insert problem?

I doubt very much that Access Security is to blame for this. Do you have a
unique index defined on each table in Oracle?

I have a database in Oracle XE with an Access front end. It connects
successfully via ODBC without any problem. All the data is accessible but

[quoted text clipped - 10 lines]

change.
Other suggestions, please? Thanks!

 

[Arvin Meyer [MVP]]

Possibly. A memo field is an OLE field and is not actually stored in the
same table. What is stored is a 14 byte pointer to the actual data (of
course we don't see that). To tell for sure, clip the Oracle record to less
than 255 characters and map it to a text field.
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Yes. I went ahead and rebuilt them just to be sure. Would mapping a memo
field to a VARCHAR2(4000) create an update or insert problem?

I doubt very much that Access Security is to blame for this. Do you have a
unique index defined on each table in Oracle?

I have a database in Oracle XE with an Access front end. It connects
successfully via ODBC without any problem. All the data is accessible
but

[quoted text clipped - 10 lines]

change.
Other suggestions, please? Thanks!

 

[Rick Brandt]

Yes. I went ahead and rebuilt them just to be sure. Would mapping a
memo field to a VARCHAR2(4000) create an update or insert problem?

Open the linbks in deswign view and see if a primary key is indicated on the
appropriate fields. The look at the indexes to see if one that is unique is
identified. If not then that is your problem.

Security would not gray out the "Go to new" button. It would just give you
an error when you tried to save a new record.