I've been looking at moving validation to application tier objects and out of the DBC. Having problems in SQL Server that are sorta related.
>>I didn't see views mentioned so I'm not sure if ODBC comes into play. Me no like database-level code anyway :-)
>
>Me no like it either but in some cases in might be a necessity I think. For example, I need an extensive VFP app that uses local data and the client wants to query and report against that data in Access. Granted I can setup read only access fairly easy, but I also want to protect that data from the average power user to ensure my VFP app never fails due to external playing.
>
>And the darn messagebox with fox head on field level validation is one of my pet peeves with VFP.
------------------------------------------------
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