access linked excel table error opening in .asp

[bazango]

Hi.

I am trying to use ODBC to connect to a linked table in Access. My VBscript
connection looks like this:

cnn.Open "driver={Microsoft Access Driver (*.mdb)};DBQ="&
Server.MapPath("myDB.mdb")

Then my query:

sqltext = "SELECT * FROM myLinkedTable"

The error:

The Microsoft Jet database engine cannot open the file
'\\myPath\myLinkedTable.xls' It is already opened exclusively by another
user, or you need permission to view its data.

But... it's not open and permissions are set correctly. If I substitute a
local table for the linked one, it works fine. What am I doing wrong? Coming
to work in the morning? :-/

Sure appreciate any help.

Thanks.