Read-Only Table? 
Author Message
 Read-Only Table?

I have linked two tables via a one-to-one relationship on the same primary
key field (an autoincrement "ID" field).  When I try to produce a form to
input data into one of the tables I find that the "recipient" table is
declared "read-only" and will not accept data or allow searches.  If I swap
the tables over (ie the link points the other way) then the other one
becomes "read-only".  If I produce a form just for one table (either one)
then I can input data and search OK.  What am I missing here please!??
Thanks
Chris Neave


Sun, 09 Jun 2002 03:00:00 GMT
 Read-Only Table?

Chris:
For *some* reason, PDX adds these links as readonly in the data model.  Show
the DM, right-click on the errant table, and un-check READONLY.

HIH.

Russ

Quote:
>I have linked two tables via a one-to-one relationship on the same primary
>key field (an autoincrement "ID" field).  When I try to produce a form to
>input data into one of the tables I find that the "recipient" table is
>declared "read-only" and will not accept data or allow searches.  If I swap
>the tables over (ie the link points the other way) then the other one
>becomes "read-only".  If I produce a form just for one table (either one)
>then I can input data and search OK.  What am I missing here please!??
>Thanks
>Chris Neave

Russ Carmichael

'You can't be a Real Country unless you have a BEER and an airline. It helps if
you have some kind of a football team, or some nuclear weapons, but at the very
least you need a BEER'  Frank Zappa


Mon, 10 Jun 2002 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. ReadOnly Table in ReadOnly Directory

2. readonly tables in access2000 adp projects????

3. Read only tables in Access?

4. Read only tables after linking Access-SQL Server

5. can only read sqlserver-tables in access2000 projects

6. READONLY TABLES

7. Large read-only table for queries - what index?

8. Reading System Table Data via functions

9. Can't read from table!

10. Cannot specify UPDLOCK or TABLOCKX on a read-only table in a cursor

11. Read Only Table


 
Powered by phpBB® Forum Software