Sami, Thanks for the help. I went home and had the exact same problem so I figured it was something I did. I followed your idea #3 and looked at the lookup. Actually deleted the table and rebuilt a new version. It was only three columns and one row to develop the form. Now it works correctly. I kept a separate copy of the problem and will go back through it with your other ideas to see if the problem pops out. I learned early on to save forms regularly to avoid similar problems so understanding what caused this new issue will become the Lesson of the week for me.
Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org ________________________________ From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Sami Aaron Sent: Monday, February 04, 2008 1:28 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: Access violations Tom, Here a few things I'd try: 1. Reload the database - it's possible there is corruption in the index file 2. Check that any referenced variables in your WHERE clause are "dotted" variables and make sure quotes and parens are balanced 3. If the error only occurs when you try the TEST WHERE clause button, then it must be related to the lookup you've defined. Pay attention to the data types of the column you are looking up vs. the data type of the column you will place the value into - and things like that. God luck! Sami ____________________________ Sami Aaron Software Management Specialists 913-915-1971 [EMAIL PROTECTED] From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Tom Frederick Sent: Monday, February 04, 2008 11:48 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Access violations I started getting access violations with V8 this morning for no particular reason that I can tell. (Build 8.0.16.30102) I am setting up LookupComboBoxes with lookup settings in a form and saving regularly. Form has 3 tabs with several Lookups and other options each. I use this basic format a lot (some forms are really loaded with Lookups) with no problems. When clicking on the Test Clause button in the Where Builder section, an Error notice pops up and these messages appear. V8 will flicker for awhile then simply turn off. Access violation at Module Write of address 017E6414 RBengind8.dll 20202020 018BBFEE RBengind8.dll 7461446C 00AC430 RBG8EE.exe 00000000 00AAF6C5 RBG8.exe 00000000 Temperatures in the machine are fine. No memory hogs or internet radio in the background. Machine is on a LAN with protections. Machine was off over the weekend worked great late Friday. Restarted machine and had a repeat. Later came back after a phone call and everything worked fine for 10 minutes then a repeat. I will likely simply scrap the form and start over in case I saved something goofy. I will check my copy at home to see it the same thing happens there, but have had no problems there. This issue has not happened with any other form on the same machine. Any other suggestions? Tom Frederick Elm City Center 1314 W Walnut Jacksonville, IL 62650 Off - 217-245-9504 Fax - 217-245-2350 Email - [EMAIL PROTECTED] Web - www.elmcity.org
