Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data safe from users
Message
From
11/04/2002 06:10:29
 
 
To
11/04/2002 05:51:21
Bruno Maddalozzo
Informatica Aziendale
Arsie, Italy
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00643606
Message ID:
00643614
Views:
6
>In a multi-user (medical) application, I would like to put shared-data on a server, in a folder not accessible by clients using Windows-explorer. In this way it becomes impossible to damage, destroy, ..., the data, by the users themself.
>Of course the VFP program installed in the clients must access the data, to change them.
>
>I tried to put the 3DatabaseFiles in a shared folder (folder "DatabaseOnly" mapped as L: in the network), then "hide" the tables on a same-level-server-folder named "Tables", not shared, but with full permissions. In the project I made the references Database-Tables, so that its possible, at project-level, to open the database and then the related tables.
>
>Unfortunatedly, from the client I CAN open the database (OPEN DATABASE L:data1 SHARED), but when I try to open one of its related tables (USE TableA IN 0 SHARED), the result is "File TableA does not exist".
>
>Is there a solution to this problem, or an alternative way to get data "safe" from users on the network, other then using a COM object?

If the user has rights to the file, then that user, using Explorer, also has rights to the file. Short of using a COM component or string the data in a backend such as SQL Server that is noit accessed directly at the file level by the user, you're stuck.
EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
- Firesign Theater


NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys
Previous
Reply
Map
View

Click here to load this message in the networking platform