Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

connecting to an Access DB

Status
Not open for further replies.

bmorris

Programmer
Apr 27, 2001
8
US
I'm using dreamweaver for my web design. I have two recordsets I created,when I run my page it blows up on the 2cnd rs. "Cann't use UNKNOWN, file in use"? Any one have any ideas. I let Dreamweaver set up the code for the RS. Works fine with SQL do I need to do something different with Access?
 
It might be trying to open yet another connection to the database -- Access doesn't handle concurrent connections very well...

Without seeing the code that you are using, it's really just a guess, though -- and that'll be about all you get w/out any code.

:)
Paul Prewett
penny.gif
penny.gif
 
It looks like it may not be trying to access the database correctly. Are you using the same connection string to access the database as the 1st RS? You might try closing the 1st RS before opening the 2nd RS.

Trav...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top