Adobe Acrobat ODBC to access databse slow in Windows 7
Posted on 2011-10-31
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?