It works for me. Only thing else can do is provide your file for analysis. Follow instructions at bottom of my post.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thank you all for the help. I believe I have figured it out. The problem was that I had "Microsoft DAO 3.6 Object Library" enabled when I needed "Microsoft Office 12.0 Access database engine Object library" enabled in order to use Recordset2, field2 and Savetofile. Essentially, I had to disable DA0 3.6 and browse for ACEDAO.DLL in C:\Program Files\Common Files\microsoft shared\Office12\. Everything worked after I did that.
Should I rename the thread to "Error using Recordset2, SavetoFile or Field2" so future posters can find the solution?
Done. But when I rename the thread title in advanced, it only changes the title of the post. It doesn't let me change the thread title. Is there some other way.
Thanks again.
Actually, the thread title is just fine. Let's just leave it alone. Thanks.