Let me start with a few general questions.
1. I have moved virtual all of my code in snippets to objects in the Design Menu Bar option. It's clean, sometimes redundant, but certainly makes debugging easier. Are there any "tilt" or performance issues to worry about? I realize that it all goes into file 4 and I'm interested in any short or long term pros and cons.
2. It looks like all forms and reports take a 32kb block in File 4. I like having a different form running various reports and program options. Although it seems wasteful, I have a different form running each option. At about 200+ forms and reports that would make File 4 about 7mb. Again, any concerns for a multi user network app? I understand that many folks have giga byte applications, but that's File 2.
3. And LBNL (for this email) I have moved a lot more data validation into my forms and it would seem that I can remove a "shipload" of constraints. I noticed that at some of my customers where some tables have Not Null constraints on many columns, it seems prudent to do a little clean up and free up some overhead in File 3 processing. Any suggestions here appreciated.
TIA,
Dennis ***** Dennis Fleming IISCO http://www.TheBestCMMS.com Phone: 570 775-7593 Mobile: 570 351-5290
