Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to block Excel from openning my tables?
Message
From
03/05/2002 11:48:35
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00650986
Message ID:
00652460
Views:
20
>May I make a couple radical suggestions:
>Suggetions One:
>
>USE filename.MYT works just as well as USE filename
>
>1) Use the table as a free table
>2) Remove the compound index and use a regular index (IDX) instead
>3) RENAME the the table with a DIFFERENT Extention than DBF like MYT.
>
>This will stop the non-sophisticated user, because EXCEL will look for a *.DBF and not a *.MYT file. So when they change the file type in the Open Dialog window your table will not be listed.
>

Security by obscurity. Won't work for long.

>Suggestion Two:
>
>You can implement a programatic non-sophisticated, encryption or otherwise scramble method. Therefore, making your data unreadable and useless to anyone using anything but your program to open the files.

I suppose Bryan could do that. Or he could use SQL Server... :)
Steve Gibson
Previous
Reply
Map
View

Click here to load this message in the networking platform