bguidry
02-22-2011, 02:21 PM
I have a "Make-table" query, based of the source table being a linked Excel spreadsheet, which I know are read-only, and therefore I think is the reason I am getting an error in code "Recordset is not updateable" when attempting to open a 'Hyperlink' field in the destination table.
From reading, it seems I need to make the query properties set to "Inconsistent updates" somewhere. Can someone help me find where to set this?
From reading, it seems I need to make the query properties set to "Inconsistent updates" somewhere. Can someone help me find where to set this?