Bill
>That is great for a form but what if someone uses the table interactivly outside of your form. None of your software ever knows about it or runs.
You can go to a distributed architecture, with COM .dll's running inside of MTS accessing your tables in a restricted directory. MTS can handle the user restrictions by various permissions, and your code in the COM object can further restrict things if you wish.
That way you can keep the tables locked up where they can be accessed only through the designated COM objects.