Reserved Error -1517: can't run append query on linked spreadsheet

[mbannen]

Just started getting this error message today. Factors to consider:

- have an access data with 20 some excel spreadsheets linked into it
- have a copy of the database in 97 and a copy in 2002
- the spreadsheets are in Shared Workbook mode, and are being used by both Excel 97 and Excel 2002 users (there have not been any problems with either the shared workbook mode, or with having users on different versions of excel sharing the workbooks).
- have append queries for each spreadsheet, which take the entire contents of the spreadsheets (which are all laid out the same) and append the contents to a single table

This was working great until today. Now, when I run some append queries I am getting the "Reserved effort (-1517)". I can still view and run non-append queries on the linked spreadsheets, but cannot run the append queries. I tried deleting all the data from the append-to table and rerunning the queries, but still get the error. I only get the error on some of the linked spreadsheets.

PLEASE HELP!!!

 

[zoroaster]

Did you ever discover what Reserved Error (-1517) is?
I've been getting it on a db when I've been running an update query..

Laters, Z

"42??? We're going to get lynched!

 

[MePenguin]

Don't know if anyone is still on this, but I recently encountered the error in Access 2000.
It occured when I tried to open a particular form where the recordsource was a query that retrived fields from linked tables.

Running the "Linked Table Manager" solved the problem... although didn't give me an explanation...