I am not sure what do you mean by refreshing your model, but I can think of
1. Model is server-side changed (using Analyses Manager or DSO), while
OleDB clients are still connected to the server.
In this case you do not have to do anything - just go ahead and re-train
the model. The clients will get automatically the new model.
2. You want to change / train the model programmatically
You can do this only through DSO due to security reasons (and the user has
to be an Olap administrator). Altering a server side mining model is a
surgical operation, i.e. an administrative task.
In a VB project you have to reference "Microsoft Decision Support Objects".
The code should look like:
Private Sub Command1_Click()
Dim srv As New DSO.Server
Dim mds As DSO.MDStore
Dim mm As DSO.MiningModel
On Error GoTo ErrH
Set mds = srv.MDStores("MyDatabase")
Set mm = mds.MiningModels("MyMiningModel")
Set mm = Nothing
Set mds = Nothing
Set srv = Nothing
' Cleanup stuff
Hope this helps...