Access simply not capturing data

[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.

 

[Tim Ferguson]

Is this a bug in Access?

Without seeing the relevant code, who can tell?

Tim F

 

[TC]

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

 

[Larry Linson]

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.