data input not possible in linked/connected databasetable without

03/09/2007 - 09:12 von Michael Fees (Germany) | Report spam
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.
 

Lesen sie die antworten

#1 Henry Habermacher
03/09/2007 - 10:02 | Warnen spam
Hi Michael

German would be fine here, too ;-)

Michael Fees (Germany) wrote:
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.



Did you add both fields (even if they contain the same value) of the
relationship?

If you join a table to another you have to do the join by at least one
field. The child and master side have to be in the query to make it
insertable. This condition alone doesn't make it insertable yet but without
it it's surely not.

To the linked table without keys. You may add an artificial key over a
certain amount of fields to get a unique key over the linked table if you
don't have the possibiility to link it with its primary key. Without a
unique key you will not be able to update this table. You may add the key in
Access also for a linked table. The key is then stored as definition in
Access/Jet but not in the originating table.

HTH

Henry



Microsoft MVP Office Access
Keine E-Mails auf Postings in NGs. Danke.
Access FAQ www.donkarl.com

Ähnliche fragen