[thelist] Access - adding record problems

[Ed McCarroll]

Just a hunch, ... probably irrelevant to your question, but ...

I don't know VBscript, but if this was VBA, I'd be suspicious of
any code that did the following.  First you use SET, and then an
"=" assignment, to assign the same object variable.

>   Set adoCon = Server.CreateObject("ADODB.Connection")
>   adoCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="
>       & Server.MapPath("dbs\CustInfo.mdb")

and again:

>         Set adoReferralCon = Server.CreateObject("ADODB.Connection")
>         adoReferralCon = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ="
>             & Server.MapPath("dbs\CustInfo.mdb")

I'd also be curious as to why you go to the trouble of opening the
same connection (adoCon and adoReferralCon) twice.

Just a stab in the dark.  Educate me, if you like.

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Ed McCarroll                          MailTo:Ed at ComSimplicity.com
ComSimplicity                                      (310) 838-4330
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -