>Jim,
> Perhaps I'm missing the point but I am still able to open the table I tested with the VFP command window and also from Excel. By the way, where is MyValidCheck() defined.
> Also, it can be noted that Access has security for the .mdb file. Microsoft certainly didn't tell Access users to upgrade to SQL Server if they wanted security (just an observation).
>
>Thanks,
Bill,
I'm showing you pseudo code, you have to write the Mywhatever() function. Yes they can openm it in excell but they cannot change anything because the validation rule will fire and the variable won't exist and the update will fail.
If you want robust security for your data you MUST go to database server of some kind. That is the only way you can do it because that is the only way you can have data that cannot be seen as simple disk files. You can use the network security to limit access to a degree but even that isn't as robust as the security provided by Oracle or SQL Server.
Its anagolous to needing to move $20,000,000, you could use your car but you'll get much better security if you use an armored truck.