MS Access - Select Query and Updating Data

[Vogel515]

In Excel, I created a table of rows I needed to update, I imported this table into access as Sheet1.

Then I created this select query to produce an easily updated view of the data:

SELECT RawFinancials.*
FROM RawFinancials INNER JOIN Sheet1 ON RawFinancials.Prj = Sheet1.Prj;

The problem is, once I run this query, it does not allow me to update any of the data. Can someone please explain to me why this is happening? I did the exact same thing for another query and it worked fine.

 

[Vogel515]

What the...

I post this message and now its fixed. No rhyme or reason, can someone please explain to me what the issue was? Some sort of key combination that locked the table?

I didn't have any of the tables open....

 

[Evadman]

Access couldn't figure out which rows to update. Sheet1 and/or RawFinancials probably did not have a primary key, or were not unique enough for Access to figure out which rows actually needed update. There are many more possibilities, but that is the most likely.

 

[KLin]

Originally posted by: Evadman
Access couldn't figure out which rows to update. Sheet1 and/or RawFinancials probably did not have a primary key, or were not unique enough for Access to figure out which rows actually needed update. There are many more possibilities, but that is the most likely.

This. Access can be quite picky about what it allows you to update in datasheet mode through a multi table query.