Tull,
It sounds like you are using a single OleDbConnection object, and attempting
to use multiple OleDbDataReader objects.
You can only have a single DataReader object in use for each Connection
object.
If you in deed want multiple connections open at the same then, then you
need to create multiple OleDbConnection objects.
Hope this helps
Jay
"Tull Clancey" <tu**@idcodeware.co.uk> wrote in message
news:u%****************@TK2MSFTNGP10.phx.gbl...
| Sorry I haven't posted code, I'm using the basic OLEDB connection and
| the DataReader, DataAdapter etc. objects.
|
| When I try to open a second DataReader or Adapter I'm told that a
| connection is already made and I can't make another.
|
| Going back to DAO and ADO you could open one database connection and as
| many recordsets as required.
|
| The reason is I have to open a couple of tables and write values to
| another at the same time, SQL joining just wont do the trick.
|
| Cheers,
| Tull.
|
| *** Sent via Developersdex
http://www.developersdex.com ***