Printable Version of Topic

Click here to view this topic in its original format

UtterAccess Forums _ Access Errors + Error Handling _ error 2101 - setting not valid for property

Posted by: glue Jan 12 2006, 01:10 PM

My database just threw this error for two users 32 seconds apart:
rror 2101:
The setting you entered isn't valid for this property. To see the valid settings for this property, search the Help index for the name of the property.
Ocan't reproduce it. And the function seems foolproof to me:
(bnOkayToSave is a module level boolean variable)

Sub forceSave()
'this function is called to legally save changes to a record
On Error GoTo errForceSave
    If Dirty Then
        bnOkayToSave = True
        Dirty = False
        bnOkayToSave = False
    End If
    Exit Sub
    LogErr "Form_Mainform", Err.Number, Err.Description, "forceSave"
    Resume exForceSave
End Sub

any insight appreciated!

Posted by: GroverParkGeorge Jan 13 2006, 01:47 AM

WAG: Possibly a blip in your network caused them to lose their connection momentarily?

Posted by: glue Jan 13 2006, 12:51 PM

Thanks, but it must be something else... it happened again today.
nother clue on my end is that for the first user, it happened once. For the second, four times successively (and the records are indeed saved), and the third user today, three of these clusters of four...
I'm thinking I must be missing an error handler further in that allows the error to propogate back to my forceSave function, at least that's where I'll be looking now.
Now I've looked into the error handlers on the form events, and that seems to be ruled out too.
I have Load, Unload, BeforeUpdate, Current, and KeyDown events, all with error handling as above. So even if one of these, triggered by saving the record, called a function without proper error handles, it wouldn't propogate back to forceSave, right?