losing some parts of DB

A

Alkarion

hi^^

well i´m doing some forms for use on my work, and soemtimes I lose some
lines of information, like I was never placed any info on it.

so I want know how I can fix it, so I don´t lose any more data on my DB, i´m
using access 2003, so anyone know how I can work on it?
 
A

Allen Browne

Under what conditions do you lose information?

One known bug is when you close a form and the record is not saved:
http://allenbrowne.com/bug-01.html

Another common scenario is when you enter a record in a subform when the
main form is at a new record. The record does go into the subform's table
(with a null in the foreign key field), but since it does not match anything
on the main form, it never shows up in the form again.

If you are connecting to a data file across a network, and the connection is
intermittently flakey, you should be getting error messages about not being
able to get to the data file. This has a high probability of corrupting your
database.

If you are experiencing data corruption, this may help:
Preventing Corruption
at:
http://allenbrowne.com/ser-25.html
 
A

Alkarion

thanks for the information.

and yes my db is on the network of my work, sometimes when I close a form
the data is not saved also, so after i read these links I will try to solve it

"Allen Browne" escreveu:
 
Top