ewarman
asked on
Adobe Acrobat ODBC to access databse slow in Windows 7
Hi,
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?
Thanks.
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?
Thanks.
ASKER
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
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:
http://blogs.adobe.com/formbuilder/2006/09/connecting_a_form_to_a_database.html