Unable to read DB - Locked Link Table

  • Thread starter Thread starter bamnet
  • Start date Start date
B

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
 
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)
 
Back
Top