Access 2000 query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,
I have a question regarding a query I just did but cannot input data into. I
created a new table with five fields. I then created a query using fields
from two different tables. Now that I have my query in datasheet view I
cannot input any data into any fields. When I attempt to do so I get a
ringing sound...ding ding. Its as if all the fields are frozen. Does anyone
know what I can do? Thank you.
 
You have created a nonupdatable query...very easy to do when you write a
query that involves multiple tables.

Here are some articles in Microsoft's Knowledge Base about this issue:

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