David,
Have you looked at DataClass, John Peterson and Jim Duffy's classes for managing this sort of thing? It might save you a ton of effort. Check out the product info at
www.redmatrix.com.
>Right now, I am playing with an object(component?) that just handles user-maintenance. This object will have methods exposed to handle Adding, editing, deleting, and retrieving user information. Right now, I am exposing the 1:1 data elements (User name, employee badge id#, first name , last name, etc) as properties of the object which the GUI would manipulate and then issue the appropriate method (add, edit, delete, get, etc). By using the properties I am running procedures in the PROPERTY LET snippets to make sure that the data is formatted correctly (i.e. left-justified and upper-case). From here I am using a ADO recordset to write back to the DB. I have also seen this done by performing native SQL to the back-end.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05