>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
By seperating application login from sql server login. I.e. User starts the application using one login and the application from within itself connects to the sql server using another hidden login.
All the best.
A moment of silence is our cosmic reset button.