Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Access database connection

Avatar

03-12-2008

Hello:



I noticed your response on the Adobe web site. I am working with Lifecycle and I am trying to connect to an access database.



I step thru the setup and I get a Connection Successful message.



When I open the form it finds the first record in the table but that is all I get.



I want to be able to put in an employee number on the form and it will auto fill the employee information like First Name and Last Name.



Just like a lookup does.



Is there a way to get this done?



Please help.



Thank you



Jeff Wilson

South Dakota

Replies

Avatar

Avatar
Level 2
_Jenn_Dickens_
Level 2

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
_Jenn_Dickens_
Level 2

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
View profile
_Jenn_Dickens_
Level 2

12-12-2008

OK, I got creative with part of it. I only have one person that needs to fill in the doc number and corresponding information. Then she will distribute it to the engineer who needs it. They will fill out their portion and submit back to her.



What I did... I created a form (in Access 2007) with all the information that will need to go on the pdf form. I placed a hyperlink in my access db form that opened the pdf form. The pdf form is told to populate the fields with the last record of the sourceset. She will distribute and then it will get submitted back to her when engineer finishes filling it in.



The next step... getting the engineer's info into the database in the correct location... hopefully I can figure that out too!



Jenn D.

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

12-12-2008

So yes you can do what you want,,,,,,BUT - by using database connections on the form you will have to setup a Data source on each persons machine. The form needs to make use of this DSN to be able to acces the DB. Also the DB needs to be in a shared loacation so that each person can get at it and lastly if you intend to use Reader you will have to Reader Extend the form to allow Reader to do Database access (this can only be set by LiveCycle Reader Extensions not by Acrobat). Do you still want to proceed?

Avatar

Avatar
Level 2
_Jenn_Dickens_
Level 2

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
_Jenn_Dickens_
Level 2

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
View profile
_Jenn_Dickens_
Level 2

12-12-2008

Not the way I had originally thought I wanted to. I have come up with a creative work-around though. (See previous posts in this discussion).



I'm almost to a point that I can start experimenting with how DC can send the engineer's info to the database once they submit it back to her.



I really appreciate you taking the time to respond to my posts. I hope you have a great weekend!



Jenn D.

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

12-12-2008

Getting the data from the form into the Access form will not be so easy. If it is only one user who is accesing the DB you can put Acrobat on their desktop and have the PDF add the records to the DB directly.

Avatar

Avatar
Level 2
_Jenn_Dickens_
Level 2

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
View profile

Avatar
Level 2
_Jenn_Dickens_
Level 2

Likes

0 likes

Total Posts

18 posts

Correct Reply

0 solutions
View profile
_Jenn_Dickens_
Level 2

12-12-2008

That is what I intend to do. (I do not need it to go into an Access form, just the database so that the information is usable for reporting). I haven't actually done a distribute/submit in Adobe 9 yet so I'm not sure how/if it differs from 8.0. If I can collect the 'submitted' forms and 'export' the info into the db in a sensible manner, I think that it will all work the way we need it too and everyone will be much happier than they are with the current system.



Thanx a bunch! Jenn D.

Avatar

Avatar
Validate 1
Level 2
ibwaheemi
Level 2

Like

1 like

Total Posts

31 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
ibwaheemi
Level 2

Like

1 like

Total Posts

31 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
ibwaheemi
Level 2

12-12-2008

Paul i set up an ftp link for you to post stuff in



ftp://adobe:livecycle@paulguerette.kicks-ass.net/livecycle



it would help us learn from you



your knowledge and willingness to help is inspiring

Avatar

Avatar
Validate 1
Level 1
KRM240_
Level 1

Likes

0 likes

Total Posts

34 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
KRM240_
Level 1

Likes

0 likes

Total Posts

34 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
KRM240_
Level 1

07-04-2010

Hi all

The issue that Jenn was working on is exactly what I need too.

I am looking for a solution that 1 single user changes a few criteria fields, using adobe pro,

Once the criteria is set, download the appropriate data from a database (Acess or Sql)

Then send the form to 1 user for completion,

they will send it back to a user who will update the database.

Jenn's issue sounds just like mine.

Anyone know how this was resolved or suggestions as to where I should look for a solution?

Avatar

Avatar
Validate 1
Level 2
Jstaab
Level 2

Likes

2 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile

Avatar
Validate 1
Level 2
Jstaab
Level 2

Likes

2 likes

Total Posts

30 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 1
Affirm 1
View profile
Jstaab
Level 2

31-08-2010

Hey Paul:  Could you email the sample to me on selecting a specific record from an Access database.  Thanks.  Tracy

Tstaab@spokanecity.org

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

611 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

01-09-2010

Better yet here is a link to a blog entry that explains it as well.....

http://blogs.adobe.com/formbuilder/2006/09/selecting_specific_database_records.html

Paul