After upgrading from XP SP1 to XP SP2 get "operation is not allowed when the
object is open" error messege. the app in production stop working properly.
The refresh method is available, but fails. Here is the code:
With Adodc1
.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security
Info=False;Data Source=" & App.Path + "\PhoneNumbers.mdb" & ";
Mode=Read|Write"
.RecordSource = "select * from PhoneNumbers Order By Name"
.Refresh
End With
I need a solution in production,i.e I won't install the IDE in production.
Any ideas?


Tony