• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 394
  • Last Modified:

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.
0
ewarman
Asked:
ewarman
  • 2
1 Solution
 
puppydogbuddyCommented:
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 connectionstrings.com

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
0
 
ewarmanAuthor Commented:

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.
0
 
ewarmanAuthor Commented:
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.
0
 
James MurrellProduct SpecialistCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now