edit querys with joined keyless tables

  • Thread starter Michael Fees (Germany)
  • Start date
M

Michael Fees (Germany)

Hello,
I have to use a linked/connected (in German verknüpfte) foreign
databasetable (Table-A) with personal names without keys.

When I try to edit a regular Access query with a regular Access-Table
(Table-B) in Access it works, that I can edit values in that query.

When I try to display the personal informations with a Join into this query
I can't insert anything. I believe that this problem is because the
linked/connected databasetable has no key.

I didn't find a possibility to add a key when I linked/connected the foreign
databasetable.

Has anyone a solution how I can edit values anyway?
Thank you for your help in advance.
Michael.
 
S

scubadiver

You can't link tables from two different databases (if that is what you are
asking!)
 
P

Pieter Wijnen

Yes you can!

You can also create a unique index for the foreign table in access
in a query write
CREATE UNIQUE INDEX P_TableName ON TableName (FieldName) WITH PRIMARY

Replace TableName & FieldName with your table/Field

HTH

Pieter
 
P

Pete D.

You need to look at help in access and read/search for,When can I update
data from a query? (MDB). I think you'll find your problem.
 
J

John W. Vinson

When I try to display the personal informations with a Join into this query
I can't insert anything. I believe that this problem is because the
linked/connected databasetable has no key.
Click to expand...

If your remote table has no key, how can you identify which record is which???

Suppose you have five people named Hans Schmidt, all with different data.
Which one is which? Which one do you want to use in the update query?

You MUST have *some* way to uniquely identify a record, or Access cannot be
expected to update any records - because it can't reliably tell *which* record
needs to be updated.

John W. Vinson [MVP]
 
Top