Having a problem with multiple Access connections.

[scuttleButt]

I am working Dreamweaver UltraDev 4. I am using an Access database in which I am making 3 record sets. First lines of code to create the first record set is,

set rsCpcOwners = Server.CreateObject("ADODB.Recordset&quot
rsCpcOwners.ActiveConnection = MM_nappi_STRING
rsCpcOwners.Source = "SELECT distinct chartOwner FROM cpc"
Blah, blah....

Next DW creates the second record set
set rsRedOwners = Server.CreateObject("ADODB.Recordset&quot
rsRedOwners.ActiveConnection = MM_nappi_STRING
rsRedOwners.Source = "SELECT distinct chartOwner FROM red"
Blah, blah....

All connections test fine but when I run it through the browser I get an error, "Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use."

It is bombing on the second connection line, "rsRedOwners.ActiveConnection = MM_nappi_STRING"

the connection string is:
MM_nappi_STRING = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=E:\Root\Cnatra2\private\nappi.mdb"
That connection tests fine too.

Any suggestions?

Thanks,
Donna