"Operation must use an updateable query"?

> Nope, I'm inserting into a table. I mean, I could paste my code, but > it's just a little Access table. I mean, it's nothing even *remotely* > complex. That's why I'm so stumped. It's just a regular little Access > table, and all I did was use the record insertion wizard. >    I assume your MSAccess table is linked to another. I've never ran into this unless I was trying to link two Access tables together when trying to run an 'update' query. Try devising a way to obtain the information from both tables (via the link), then run a separate update query against the one table. Note: When you run a select query in MSAccess and the 'asterisk-navigation button' at the bottom is greyed-out, then you know it is not an updateable query.