Thanks Bob
Do you think it would be possible to put a password in a trigger (Is there an access database trigger?) when accessing the database ? It would not be full prove but will at least make it more complex to access wouldn`t be ?
>>When using a database on a network with an application, is it possible to restrict the access of the database so it is only possible to access it with a password or not on side of the application.
>>Thanks
>>Eric.
>
>You can't just take a file server app as it is and secure the data... however there are some third party products that can help.
>
>1. There are programs that will give access to a resource and then launch an ap... once the ap is exited the access will be revoked. Sorry, no specific names for this.
>
>2. You could set up a Citrix or Windows Terminal Server... the user would have to log into Cirtix, and never have access to the files.
>
>The above two require no modification to your application.
>
>If you wanted to modify the ap, physical n-Tier seperation would acheive this also... The client would talk to a COM object... The COM object would run as a user that you gave access to the files. This way, the client user doesn't need access to the files.
>
>You can also do this as a web ap that runs on a web server and exposes an HTML front end to the user.
>
>HTH,
>BOb