By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,506 Members | 1,881 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,506 IT Pros & Developers. It's quick & easy.

saving data

P: n/a
Hi,
I've a question regarding saving the data. I noticed some of my
recently-entered data mysteriously disappeared. There was nowhere to
re-locate them. Plus, those data were entered within the same week. My
colleagues and I have been cautiously avoided working on the same table
simutaneously. Any reason why the data got lost?

I appreciate your advice!

Yang
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
All versions of Access have a serious bug where they silently lose your
entry when you close a form if there is any reason why the record cannot be
saved. Details in:
Losing data when you close a form
at:
http://members.iinet.net.au/~allenbrowne/bug-01.html

The other case that often catches people out is that the data can seem to
disappear from a subform if you have not set your foreign key's Required
property to No. It is actually there in the table, but never appears in the
subform again, since the null foreign key does not match any record in the
main form. Note that this happens even if you have created a relationship
with Referential Integrity.

More information (and a 3rd case) in article:
The Query Lost My Records! (Nulls)
at:
http://members.iinet.net.au/~allenbrowne/casu-02.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps.org.

"R. Yang" <jy*****@gmail.com> wrote in message
news:cs**********@mailhub227.itcs.purdue.edu...
Hi,
I've a question regarding saving the data. I noticed some of my
recently-entered data mysteriously disappeared. There was nowhere to
re-locate them. Plus, those data were entered within the same week. My
colleagues and I have been cautiously avoided working on the same table
simutaneously. Any reason why the data got lost?

I appreciate your advice!

Yang

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.