RE: TABLE PROPERTIES
From: Dale Dedoroy
Bacolod City, Negros Occidental
To: Joriveek Joriveek
RE: Table Properties
Visual FoxPro 7
Databases, Tables and SQL Server
Wednesday, April 09, 2003 7:46:41 PM
This message was rated by:
> Hi Group,
> I have created a mydatabase.dbc, which contains a couple of Tables. Now When I open a single table, say mytable1.dbf from Windows Explorer, it opens with Visual FoxPro and I can simply change the data and even it did not bother to ask me whether to save messagebox with Yes, No, Cancel. Why FoxPro doesn't provide minimum security to the data at all? I have a stand along application running on a PC and I don't want my end user of the application to access the tables directly without the Inteface application. How can I protect the data in the *.dbf files on my PC?
Modify Database YourDatabase
Then right click and select "Edit Stored Procedures"
Cut these lines of codes and paste it to stored procedure editor:
lcPassword = ''
If !InputBox('Enter password:','Database Security',lcPassword) == "PASSWORD"
**** end of procedure****
Press CTRL-W twice.
In the command window,
Remember that password is case sensitive. Goodluck.
"Man's mind once stretched by a new idea never regains its original dimension."