No... there is no such trigger... or any out of the box security for DBC/DBF files. Have you looked into moving to Client Server... this will give you the security.

>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