Case Study: I am developing a networked system and I need to grant access to specific data in a database which is in a shared location on a Win NT server. The access to the data is limited to specific items based on the user security level as controlled by the software. All of this works fine.

Problem: by granting the programme access to the file I also open the door to direct user level access through Network Neighborhood or through mapping. I do not want to allow access to the file directly using other programs, such as Access, or even Foxpro itself, as this would make all data visible and vulnerable, instead of the data I wish to show by accessing through the specialised application.

Does any solution exist?