INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Unable to enter any data in MS Access Linked Table

Unable to enter any data in MS Access Linked Table

(OP)
I created a table using


CREATE TABLE RETREIVERS AS SELECT * FROM DBL_RETREIVERS

I created a linked table in MS Access that is pointing to this table, i am unable to enter any data in MS Access Linked Table,there are no constraints or triggers on this table in Oracle..why is it preventing me from entering any data?There are 300 rows in the table,i am trying to enter data into two columns that are currently null,all the menus are disable,like adding new record ,delete record and paste record when i right click on the table in the data sheet view in MS ACcess,very strange


RE: Unable to enter any data in MS Access Linked Table

The table must have a primary key field that Access can identify. If you look at the linked table in design mode is there a primary key?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

RE: Unable to enter any data in MS Access Linked Table

(OP)
As i mentioned in the post there are no constraints,no triggers on this table...no primary key nothing..

RE: Unable to enter any data in MS Access Linked Table

No primary key then no update. Every table in the world should have a unique key/index.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

RE: Unable to enter any data in MS Access Linked Table

(OP)
Can insertion be done without primary key or no?

RE: Unable to enter any data in MS Access Linked Table

I'm not positive if a linked table without a primary key can have records added from an append query. You might need to try and report back.
Aren't there any fields that can define uniqueness even in combination?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

RE: Unable to enter any data in MS Access Linked Table

(OP)
No there are no fields that have any condition constraint or a primary key,so no room for uniqueness

RE: Unable to enter any data in MS Access Linked Table

Add a primary key field to the Oracle table and then relink.

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close