Harry,
Question 1
In order to accomplish this you need to set up a CusMapSDT object. See examples in the VMP example application (CusVMMapSDT of VMFWMisc) for how to do this.

The reason for this is if you use the default (i.e. SDT attempts to open a table and fails), SDT doesn't know what you want it to do at this point. You could log the problem, fix the error and log it or just fix it and go on. The default VMP behavior in CusDBCSvc.OpenTable is to correct the problem (if correctable) using SDT's Repair method and move on without notifying the user.

Question 2
The answer is SDT doesn't unless you tell it to. You could run the SDT NeedUpdate() method everytime you enter the application but that takes a significant amount of time and it would probably tick off your users. You would put the code in the CheckMainDatabase method of your CtrApp subclass to make the appropriate call to SDT.

You can use a semaphor approach. This is explained in the header comments of CtrApp.CheckMainDatabase.

The comments specified above are from version 5.0 of VMP and may not be in the version you are using. If not, check out http://discussion.visualmaxframe.com and do a search on CheckMainDatabase. There was a thread not too long ago concerning this issue.

HTH.

>Morning All,
>
>Two early morning questions!
>
>1) How does SDT know when to repair a VMP or VFP table?
>Where do you put what code to implement?
>
>2) How does SDT know when to update a VFP dbc &/or tables?
>Where do you put what code to implement?
>
>Went to bed and woke up with the same questions. NO ANSWERS!!
>
>Any assist greatly appreciated.
>TIA
>Harry Inge
>**********