7878 runtime error

R

Reis Quarteu

Hi, everybody.

I hope there is anybody out there who could lend me a helpful hand in order
to solve the following issue. I am using Access 2003 to develop an accounting
app for a client of mine, and yesterday I got the following error message:
"The data has been changed. Another user edited this record and saved the
changes before you attempted to save your changes. Re-edit the record.". Its
code is 7878. It is apparently covered by the VbLR6.chm help file, and
related to 1007878 help context ID. At the moment this error took place, I
was the only user working on the database through a subform located
(obviously) inside a main form, the table which feeds the subform was not
opened, and I was even disconnected to the Internet. I have looked for
information about this error on the web, but I could find absolutely nothing
about it. :-(

Can anybody out there help me? Many thanks in advance!

Best regards.
Reis Quarteu
(e-mail address removed)
--------------------------------------------------------------------
3-in - Inovação, Informação e Interacção
www.3-in.com
(e-mail address removed)
Rua Camilo Castelo Branco, 26 - Cave Dt.º
Bairro Artur Mirandela
5300-106 Bragança - PORTUGAL
Tel. / Fax: +351 273 312 054
 
O

OldPro

Hi, everybody.

I hope there is anybody out there who could lend me a helpful hand in order
to solve the following issue. I am using Access 2003 to develop an accounting
app for a client of mine, and yesterday I got the following error message:
"The data has been changed. Another user edited this record and saved the
changes before you attempted to save your changes. Re-edit the record.". Its
code is 7878. It is apparently covered by the VbLR6.chm help file, and
related to 1007878 help context ID. At the moment this error took place, I
was the only user working on the database through a subform located
(obviously) inside a main form, the table which feeds the subform was not
opened, and I was even disconnected to the Internet. I have looked for
information about this error on the web, but I could find absolutely nothing
about it. :-(

Can anybody out there help me? Many thanks in advance!

Best regards.
Reis Quarteu
(e-mail address removed)
--------------------------------------------------------------------
3-in - Inovação, Informação e Interacçãowww.3-in.com
(e-mail address removed)
Rua Camilo Castelo Branco, 26 - Cave Dt.º
Bairro Artur Mirandela
5300-106 Bragança - PORTUGAL
Tel. / Fax: +351 273 312 054
Click to expand...

This happens when a database is accidentally opened twice.
 
D

Douglas J. Steele

Your main form and subform both don't update the same table, do they?
 
R

Reis Quarteu

Dear OlpPro:

Thank you very much for your answer. Nevertheless, that was not the case
with me. In fact, I had (and still have) two databases opened: the first one
carries all the tables of my app; the second one contains all the forms,
reports, and the VBA code of the app.

Best regards.
Reis Quarteu
(e-mail address removed)
--------------------------------------------------------------------
3-in - Inovação, Informação e Interacção
www.3-in.com
(e-mail address removed)
Rua Camilo Castelo Branco, 26 - Cave Dt.º
Bairro Artur Mirandela
5300-106 Bragança - PORTUGAL
Tel. / Fax: +351 273 312 054
 
R

Reis Quarteu

Thank you for your answer, dear Douglas.

In fact, my main form and my subform use the same table: the main form uses
it as its unique record source, where it can add new records or edit existing
record; the subform uses the main form's table only for looking-up purposes.
The subform's record source is a query which uses the main form's table to
get the value of a field that is necessary for some calculations performed by
the subform. The subform DOES NOT edit the main form's table.

Anyway, the runtime error did not happen again, so it is not one of my most
important issues waiting me to solve them...

Thank you very much for your interest.
Reis Quarteu
reis dot quarteu at 3-in dot com
--------------------------------------------------------------------
3-in - Inovação, Informação e Interacção
www.3-in.com
geral at 3-in dot com
Rua Camilo Castelo Branco, 26 - Cave Dt.º
Bairro Artur Mirandela
5300-106 Bragança - PORTUGAL
Tel. / Fax: +351 273 312 054
 
Top