Access simply not capturing data

  • Thread starter Thread starter Millicent Lam
  • Start date Start date
M

Millicent Lam

Has anyone ever experienced the following problem?

I've got an enquiry form written in VBScript and uses DAO
to send data to MS Access 2000. There are numerous
occasions where some of these forms are simply not being
captured in the database. I would say 1 in 100. There are
no errors and I know the codes do work.

Is this a bug in Access?

Thank you in advance.
 
Er, 1 in 100 forms are lost, but your code "does work"?

Sorry: clearly it does not work!

If Access lost 1 in 100 records, everyone would have been screaming about
that, for years. In fact, as I understand it, one of the primary technical
design goals for MS Jet (the database engine underneath Access), when it was
created many years ago, was: "NO LOST DATA!". So there is almost no chance
at all, that your problem is due to an Access bug.

As Tim said, who can say more, on the basis of the tiny amount of
information that you have provided?

HTH,
TC
 
Chances are pretty good that the general instability of the Internet itself,
or something in the vbscript, is causing the loss. As TC said, Access/Jet
would have been laughed out of the computer world if it lost 1 record out of
every 100.
 
Back
Top