error 7787

[Marius Kavaliauskas]

Does anyone know what error 7787 means?

Function AccessError(7787) returns empty string

 

[Brendan Reynolds \(MVP\)]

That doesn't appear to be either a JET or a VBA error number, Marius.
Trappable JET errors are numbered from 2420 to 3808 (see the help file
'jeterr40.chm'). VBA uses numbers 3 to 746 (1 to 1000 are reserved, but not
all are used) and 31001 to 31037. The error number 7787 might be coming from
a data source (are you connecting to SQL Server or another database other
than JET?) or from a referenced component. Do you have any references
included other than the default Access, VBA and DAO or ADO references? Are
you using any ActiveX controls?

 

[Marius Kavaliauskas]

if you look in ORK 2000/XP/2003 docs, there are described all errors of MS
Office

in OFF2000 / 2003 there are Access error 7785 and then 7788, ie 7787 is
skipped, but in OFF XP there is empty description of such error.

 

[Brendan Reynolds \(MVP\)]

Thanks, Marius, I learned something new today.

Unfortunately, I don't have either the ORK or Office XP on this PC. I'll ask
around and see if anyone else knows anything about this.

--
Brendan Reynolds (MVP)
(e-mail address removed)

if you look in ORK 2000/XP/2003 docs, there are described all errors of MS
Office

in OFF2000 / 2003 there are Access error 7785 and then 7788, ie 7787 is
skipped, but in OFF XP there is empty description of such error.

 

[Brendan Reynolds \(MVP\)]

Hi Marius,

Sorry about the delay in getting back to you on this - I've been off-line
for the weekend. I did a search at Google on that error number, and came up
with several hits. Ironically enough, in one of the threads, back in 1999, I
was the original poster! Here's what I wrote at the time ...

Here's a link to the search results ...

http://www.google.com/groups?q=7787...s&num=100&hl=en&lr=lang_en&ie=UTF-8&scoring=d

--
Brendan Reynolds (MVP)
(e-mail address removed)

Thanks, Marius, I learned something new today.

Unfortunately, I don't have either the ORK or Office XP on this PC. I'll ask
around and see if anyone else knows anything about this.

 

[Marius Kavaliauskas]

What happens when I write like this:

Private Sub Form_Error(DataErr As Integer, Response As Integer)
' Trap for "Write Conflict" error --> number 7787
If DataErr = 7787 Then
Response = acDataErrContinue
End If
End Sub

Are changes saved or discarded?

 

[Brendan Reynolds \(MVP\)]

I tested this in Access 2003. I expect the behaviour would be the same in
2000 or 2002, but I have not tested that. In Access 2003, the second user's
changes would be discarded, without warning.

 

[Marius Kavaliauskas]

This is bad...

I have changed some things in my code, that helped to avoid this error.

Thanks for your help.