Update Qry on Linked Spreadsheet with Different Software Versions 1

[BV874]

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!

 

[dhookom]

The ability to edit records from linked Excel worksheets has been removed for some legal reasons.

Duane
Hook'D on Access
MS Access MVP

 

[PWise]

instead of useing linked tables
create a query with this sql

SELECT [WhorkSheetName$].*
FROM [WhorkSheetName$] IN '' [Excel 5.0;HDR=yes;IMEX=0;DATABASE=FilePath\FileName;TABLE=WhorkSheetName$];

 

[BV874]

Thanks for your help.