Define Class myServer As Custom OlePublic >> Proc SaveData >> LParameters val1, val2, val3 >> >> Local lRetVal >> >> *-- validation code goes here, sets lRetVal .T. or .F. >> If lRetVal Then >> Insert Into myTable Values(val1, val2, val3) >> Endif >> >> Return lRetVal >> EndProc >>EndDefine>>Of course there is more to it than this, (like making sure myTable is in the COM server's path) but it gives the general idea. You can build a COM EXE or a COM DLL for this. Shouldn't make much difference if you will distribute it to all clients running the Access application. From within the access code, you would:
Set oSrv = CreateObject("myProjectname.myServer") >>bFlag = oSrv.SaveData(var1, var2, var3) >>Set oSrv = Nothing>>Also on MSDN read the article "Building Three-Tier Client/Server Applications with Visual FoxPro". It's an old article but should give you some ideas on building COM servers.