Adobe Acrobat ODBC to access databse slow in Windows 7

Posted on 2011-10-31
Last Modified: 2012-06-27
We have been using an Acrobat script to insert the contents of a form into an Access database.
Basically we set up an ODBC System DSN for the access database in Windows. We then have the user run a script on the Access form which uses ADBC to insert the data into the Access database.
This has worked fine for a number of years in Windows XP. Recently the person who uses this script updated her computer to Windows 7. Suddenly the script takes around 2 minutes to insert the data. It doesn't always happen. Once in a while it will work fast. But most of the time it will take an extremely long time to insert the data.
Any ideas on why this is happening and what we can do about it?
Question by:ewarman
    LVL 38

    Expert Comment

    You may need to update your ODBC driver to one that is compatible with Win 7.  You can check for the applicable connection string at

    If the connection string you are using is the correct one, then I would read the step by step accrobat tutorial and see if there is anything I missed or anything I performed incorrectly with respect to the reference source:

    Author Comment


    I just set up a DSN in Windows using the Access drivers that came with Windows 7 and just connect to the datasource name in Acrobat. I don't think you can  use a connection string in ADBC.

    Accepted Solution

    I've been playing with this for a while now. It look likes changing the buffer size to 5000 helps.
    It seems to run much faster and is more consistent. I won't know for sure until I use it for a while but so far so good.
    LVL 31

    Expert Comment

    by:James Murrell
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Update 21-May-2015: I temporarily removed the source code to make major changes to the program. Regards, Joe INTRODUCTION This article presents a solution to a question (…
    *Adobe Acrobat 9 was used for this article. Particular steps may vary depending on software versions. 1. Create a framework of your form in Word, leaving space where you’d ultimately like the Adobe fields to appear.  (Note: I use the blank lines …
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    734 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now