Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Password protect DBF
Message
From
08/05/2007 21:05:20
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01222940
Message ID:
01223656
Views:
21
You can use things like cryptor, or you can actually use the DBC to check for a password when a particular table is accessed.

See below:
Procedure dbc_BeforeOpenTable(cTableName)
*Just before a table or view is opened. Return .F. to prevent table or view being opened.
If Atc("user_info",cTableName)#0
	On Error Do ermsg
	If m.sysrunning = .T.
	On Error
		RETURN .t.
	ELSE
	 Messagebox('This table may not be accessed from outside the Service Software',48,'Nice Try')
	If Atc("user_info",cTableName)#0 And Upper(Alltrim(Inputbox('Enter Password','Password Required')))#"mwpassword"
	Return .F.
	Endif
Endif
Endif

Endproc
Rich
Previous
Reply
Map
View

Click here to load this message in the networking platform