Amilcar,

One way is to use integrated security and application roles. Integrated security is used to establish a connection to the DB. The idea is that you restrict the rights to theses users so that they cannot read/change any data when using any ODBC client. Your application then activates an application role which has the necessary rights. Application roles require a password.

Another way is to deny access to tables and views and use stored procedures for all the CRUD operations. Although this doesn't prevent someone to call a sproc from an ODBC client (e.g. Access) it makes it a lot harder for the casual user.

HTH

>Hello to everybody,
>
>I have a Client/Server application using VFP8 and SQL 2000 (via ODBC).
>
>The question is as follow: how can I do to permit the SQL Data Base access ONLY using the application and not with, for example, Excel or building a mini program using his Id and password asigned to access the application (that Id and Password is the same used in the DBC connection via ODBC)
>
>Many thanks
>
>Amilcar Pino