Search results for query: *

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