>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