> 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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:248092 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
