Hi,
I have an existing DB with linked Excel spreadsheets that I am modifying. I have users add information to the spreadsheet and run an update query to populate certain statuses. I get an error when I run the query: "Cannot update '(expression)';field not updateable".
The user who created this (no longer with the company) was running Office 2000 on XP SP3. I am running Office 2003 on XP SP2. However users running Office 2000 can run the query. Is there a way for me to update and run this without using the older software?
Thanks and have a good holiday!
I have an existing DB with linked Excel spreadsheets that I am modifying. I have users add information to the spreadsheet and run an update query to populate certain statuses. I get an error when I run the query: "Cannot update '(expression)';field not updateable".
The user who created this (no longer with the company) was running Office 2000 on XP SP3. I am running Office 2003 on XP SP2. However users running Office 2000 can run the query. Is there a way for me to update and run this without using the older software?
Thanks and have a good holiday!