Unable to Update Field

  • Thread starter Thread starter Stupid Question
  • Start date Start date
S

Stupid Question

OK, this is a stupid question but I'm trying to auto fill
a filed with data using after update: me.suspense =
me.date - 30 (Acess XP, I'm used to 2000)

After I update the date field, it tells me "Field can't
be updated" for suspense and when I try to manually
update the suspense field, it tells me the field can't be
updated. I look at the field properties and locked is
set to no.

Any ideas? Important: my tables are actually linked
excel spreadsheets and this is the only way I can do
this. I'm pulling data from another database that I
don't have access to the back end and the only way to
pull the data out of it is to place it in an excell
spreadsheet.
 
Likely your query is not updatable. In order for a query to be updatable, a
number of things must be present in (or absent from) the query. See these MS
Knowledge Base articles for more info about updatable queries:

ACC2000: Cannot Edit or Update Record on a Form
http://support.microsoft.com/default.aspx?scid=kb;en-us;209571&Product=acc

ACC2000: Status Bar Displays "Recordset Not Updateable" Message When You Try
to Update a Linked Table
http://support.microsoft.com/default.aspx?scid=kb;en-us;304179&Product=acc

INFO: Troubleshooting Errors That May Occur When You Update Data in Queries
and in Forms
http://support.microsoft.com/default.aspx?scid=kb;en-us;328828&Product=acc

ACC: Update Query Based on Totals Query Fails
http://support.microsoft.com/default.aspx?scid=kb;en-us;116142&Product=acc
 
Back
Top