Access code to Logoff SQL Server

[benaround]

Having to maintain 9 databases, I use access to run reports 9 times. I have some code to re-link tables from 1 DB to another but I have to logoff 1st before I go onto the next database.
If you would supply a hint or some code I would greatly appreciate the help.

 

[ejsmith]

Benaround -I'm sure no expert in this area -but are you using ADO to connect to the databases? I assume they are Sql Server databases - if so can you use connection pooling and just open one connection to the server? I don't really do ADO (I use DAO) - but from what I've read connection pooling is one of ADO's strengths.

 

[benaround]

Thanks ejsmith for your suggestion. As it turns out, I can delete the links 1st and then re-allocate them.

The original problem / issue was because of the account I was using, not the normal "sa" account but another sa-look-alike, was not allocated on the server I was having trouble on. I made a bad ass-u-mption of the account structure here at work.