error 7787

  • Thread starter Thread starter Marius Kavaliauskas
  • Start date Start date
M

Marius Kavaliauskas

Does anyone know what error 7787 means?

Function AccessError(7787) returns empty string
 
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?
 
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.
 
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)


Marius Kavaliauskas said:
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.
Click to expand...
 
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)

Brendan Reynolds (MVP) said:
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.
Click to expand...
 
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?
 
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.
 
This is bad...

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

Thanks for your help.
 
Back
Top