Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Joseph Dumon
 Joseph Dumon
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Pete Sass
Subject: RE: Native Tables "Another Option !"
Thread ID: 22714 Message ID: 22930 # Views: 1 # Ratings: 0
Version: Visual FoxPro 8 Category: Databases, Tables and SQL Server
Date: Wednesday, April 30, 2003 7:41:17 AM         

Hi Pete!

You mean if I do this

> In VFP 8.0 you can inside the database containers properties enable Set events on.
> Then in the BeforeOpenTable event code in your own password code. In this way
> the database is password protected and the tables cannot be opened unless you
> have the admin. password."

users wont be able to open the tables outside of my application,i.e., using Excel or MS-Access? That would be great! I'll definitely give this a try. Thanks!


> I have coded many application with Add, Edit and Delete persmissions. In these cases
> I have a VFP table with the user id and password in them and a module to maintain
> this user table. In this table I can have fields with logical flags set stored as memory
> variables in the running application that enable, or disable the Add, Edit and Delete
> command buttons on each form. If I want this security at a table level I have to add
> the table name into this user table and then with the DBF() funtion determine what
> table is being accessed and code the logic to allow Add, Edit, Delete capabilities
> down to a user login level.
> This is an option for you all from within native VFP code, and really not that hard to
> code.
> Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


Natvie Tables Posted by Joseph Dumon @ 4/24/2003 9:48:29 AM
RE: Natvie Tables Posted by Eric den Doop @ 4/24/2003 9:57:51 AM
RE: Natvie Tables Posted by Kev InAz @ 4/24/2003 9:59:36 AM
RE: Natvie Tables Posted by Eric den Doop @ 4/24/2003 10:02:32 AM
RE: Natvie Tables Posted by Kev InAz @ 4/24/2003 10:07:33 AM
RE: Natvie Tables Posted by Joseph Dumon @ 4/25/2003 4:33:10 AM
RE: Natvie Tables "Another Option !" Posted by Pete Sass @ 4/28/2003 3:51:30 AM
RE: Native Tables "Another Option !" Posted by Joseph Dumon @ 4/30/2003 7:41:17 AM