These forums are now Read Only. If you have an Acrobat question, ask questions and get help from one of our experts.

JavaScript - LookUp Access Database

Forum Index > JavaScript > JavaScript - LookUp Access Database
2008-06-24 17:38:50
Frosty
Registered: May 16 2008
Posts: 3
Answered

New to Adobe and currently have Acrobat 3D. Very good with excel but struggling with Adobe. What I'm trying to do is create a form when you input data in one field, the remaining fields will pull in the correlating data from a access database. Used VLookUp command in excel to complete this task, how do I do this in Adobe? Any advice would be appreciated.

Tom

My Product Information:
Acrobat 3D 8.1.2, Windows
Top
2008-06-26 11:38:14
#1
jbfreels
Registered: Feb 19 2008
Posts: 63
You can use Adobe JavaScript. It can connect to Access databases and query. Unless you have LiveCycle server though, you will be unable to use this functionality in Reader. Also, do a google search or search here for enabling ADBC in Acrobat. You'll need to do that before you start.
Top
2008-06-27 04:25:16
#2
Frosty
Registered: May 16 2008
Posts: 3
Must of our users only have Adobe Reader and we do not have LiveCycle server so I guess my project is dead, seeing that our IT does not want to get involved. I had used the V lookup in excel which works great. Too bad the Enable User Rights feature does not include the ability to access databases. Maybe version 10......
Top
2008-06-27 07:07:35
#3
jbfreels
Registered: Feb 19 2008
Posts: 63
No kidding! There are options for you. There are companies out there that would take your form and enable it for you for a price. Probably less than the 30k price tag (or whatever it is) for LC server.

Another option would be creating a plug-in for Reader, but if IT doesn't want to get involved then you'd have to out source it.

Good Luck

-jb
Top