Linked Excel file question.

H

HeyMoe!

I have a database that uses a linked Excel file.
If I open the linked spreadsheet as a table, I can edit it. (ie. The change
occurs in the Excel file.)
But, if I try to do the edit via a form that uses the linked Excel file, I
get told that the field cannot be updated!

Is there a form field I need to change?


(This problem does not occur to any linked database files.)
 
K

Ken Snell [MVP]

What is the record source of the form? Likely it's a query? and that query
may be nonupdatable? Post the recordsource info for us.
 
Top