Update Database with Data Access Page Spreadsheet

G

glened

I am attempting update a table in an Access database using a Data
Access Page. I am able to do it using the Columnar view of the
tables. However, I cannot update the table using the Excel
Spreadsheet view. I can modify the data displayed in the Excel
Spreadsheet view in the data access page, but I cannot push the
changes to the table. The Save button is grayed out. When I update
using the columnar view, the save button is available.

Please please please help me. I have been searching google for hours
trying to find the answer, and the MSFT help does not get me any
closer to the answer.

Thank you! my email is glened AT gmail DOT com if you want to send
the response directly.
 
Top