Unable to Update Table

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

Guest

I have a form based on a query of several tables but I could not update the
fields of the table in the query. I used to be able to do that...is there
something I'm missing?
 
Run the Query by itselft, i.e. not through the Form and see if you can
update the data in the DatasheetView of the Query. Also, check whether the
New button in the NavigationBar is enabled or not. If you can't update the
data (and the New button is disabled), your Query is not updateable.

See Access Help topic "Updatable Queries".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Access Updating inventory levels 0
Seriously, I need ideas. Fields not transferring from table to table 3
update query 2
Updateable Query Problem 9
Use Update Query to Add Fields 1
Update Query 1

Back
Top