Reserved Error (-3701)

[Kim M.]

Hi. All of a sudden my program is returning "Reserved Error (-3701)"
whenever I add a new record. When I click OK, it allows me to enter the
record, but still it worries me. Any ideas as to what would be causing this?

TIA,
Kim M.

 

[Jeanette Cunningham]

Hi Kim M.
We require some more information before we can make a guess about what to
do.
How are you adding a new record?
What table or tables are involved in this form?
Are there subforms on this form?
What is the relationship between the tables?
Are you using multi-value fields?



Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia

 

[Tony Toews [MVP]]

Hi. All of a sudden my program is returning "Reserved Error (-3701)"
whenever I add a new record. When I click OK, it allows me to enter the
record, but still it worries me. Any ideas as to what would be causing this?

Very interesting. Searching on this problem shows that four people,
including you, have had this problem in the last twelve years in the
newsgroups. With two of those people having the problem in Access
2.0. You're very special. <smile>

The commonality though is that the query in use may be slightly
unusual.

Please post the SQL of the query which is being used by the form in
which you are entering the data.

Also try creating another query with the same SQL, but copying and
pasting, and see if it still does the same thing.

Tony