Unable to read DB - Locked Link Table

[bamnet]

I'm trying to read records from a database for a little asp page. The
page executes a query against a database containing a linked table.
If I have the source database for that linked table open in Access,
the asp page dies because of what I interpreted as an exclusive lock.
I can, however, still query directly to the table that I have open in
access, leading me to believe that the linked type of table is at
play.

Small asp:
SrcDB="locking_test.mdb"
Set oConn = Server.CreateObject("ADODB.Connection")
oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath(SrcDB)

sq="Select * FROM tblInfo WHERE [data] = '123'"
set oRS1 = oConn.Execute(sq)

Error:
Microsoft JET Database Engine error '80004005'
Could not use 'linked_source.mdb'; file already in use.

locking_test contains a linked table (tblInfo) from linked_source

I've made sure to select regular open opposed to open exclusive when
opening linked_source in access.

Any idea how to resolve this problem?

Thanks for your time,
Brian

 

[Guest]

How did you create the linked table link? It is possible to
create an exclusive link, but extremely rare: the linked table
wizard does not do that. Just delete the link and re-create
with the Access linked table wizard to get rid of any exclusive
link. Of course, shared links are slightly less efficient.

I don't know enough ADODB to tell you if there is a
more likely explanation.

(david)