Very Computer

Dear all,

I've some question while changing connection string in Data
Environment.The situation is that, there are two different Access
file(which contain same tables) for two different user(USER A and USER
B).

The connection string is as follows:

deMain.cnnSeibu.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + path + ";Persist
Security Info=False"
The path in the connection string will change while using different
user.

The problem is that, when I first use "USER A" database to select the
data on  TABLE A and then I change to use "USER B" database. There is
no problem when I select data on the table other than TABLE A. But
when I also use TABLE A, the error will occur:

run-time error "3709"
The connection cannot be used to perform this operation. It is either
closed or invalid in this context

Why this problem occur?? and what I can do??

Thanks
Alan

I have seen this problem happening when we do not reset the active
connection of the command objects after opening the new connection.
When you switch between databases are you closing the connection object in
Data environment?

I would definitely try setting the activeconnection property of the command
object to the new connection once you get the new connection.

Hope this helps.

Ramesh Thyagarajan, MCSD,MCDBA
Microsoft Developer support

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Microsoft Strategic Technology
Protection Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.