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) "bamnet" wrote in message news:c5d52e81-8b90-4740-83b6-86f65b7fe967@m3g2000hsc.googlegroups.com... > 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
