>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