By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,917 Members | 1,335 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,917 IT Pros & Developers. It's quick & easy.

Query in Access cannot be updated

P: n/a
Hi folks-

this will be a piece of cake for you:

The tables
tblOne (Number, Name)
tblTwo (Number, Revenue)

are connected through a query, using one field as connector:

qryThree (Number, Name, Revenue)

The query's Name field can now not be updated. Because my knowledge
about relational databases seems to be wiped out completely, please
help me with the reason and a bypass for this problem!

Using Access XP.

Thanks mucho,

Markus
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Markus" <ma***********@epost.de> wrote in message
news:d2**************************@posting.google.c om...
Hi folks-

this will be a piece of cake for you:

The tables
tblOne (Number, Name)
tblTwo (Number, Revenue)

are connected through a query, using one field as connector:

qryThree (Number, Name, Revenue)

The query's Name field can now not be updated. Because my knowledge
about relational databases seems to be wiped out completely, please
help me with the reason and a bypass for this problem!

Using Access XP.

Thanks mucho,

Markus


Just to start with, I would advise against naming fields 'Number' and
'Name' - there are times when this might cause unexpected results in Access.
It might also help have fields uniquely identified so you can distinguish
between tblOne.Number and tblTwo.Number.

Anyway, I believe your problem lies in the indexing of the tables. Is
'Number' supposed to be the primary key of tblOne and a foreign key in
tblTwo - implying a one-to-many relationship? If so you need to have
tblOne.Number marked as the primary key and tblTwo.Number indexed with
duplicates allowed.

If you have no indexing, you cannot have an updateable query.

HTH

Fletcher

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.