Im not positive if this will work, but usuallly the MS MDAC executable will install most of the needed data access .dll's
You can find it at
http://www.microsoft.com/downloads/details.aspx?FamilyID=6a7d785f-c2e0-471d-a33b-82ad1d514737&DisplayLang=en
Josh
Thanks guys,
I had already taken out the with statement and that worked with the same field names, I was hoping you might have an idea why the With statement wasnt working, maybe pointing me to a bad reference or something like that.
jbarnett thats a much cleaner WrapFunction, thank you.
Josh
Thanks for the help mp9.
The DBEngine(0)(0).Execute sqlstatement is definitely faster than RunSql. I didnt know you could use that.
The with statement is giving me problems for some reason though
With rst
email = .email
Is highlighting .email and saying
"Compile...
Im doing what can be considered a Mail Merge. Taking Field values from one table using a Replace Function and then inserting the results into another table using a
doCmd.RunSql ("Insert ...")
My throughput is about 2000 insertions a minute, does anyone think this can be speeded up, it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.