[thelist] Access - adding record problems
Ed McCarroll
Ed at ComSimplicity.com
Tue Jul 22 08:58:24 CDT 2003
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
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
More information about the thelist
mailing list