Connecting and populating XDP/PDF on a Server with MS Access datas

[Former Community Member]

Hi! I've a similar Thing to do. I've figured an XDP file, with some Dynamic Data Fields, which is populated by connecting an MS Access Database. The file work, for now, correctly in localhost. I want to make it working via HTTP. The client , after log in , with his Username and Pwd , should open the file just by clicking on a HTTP Link with the variables attached, like as :

http://www.mydomain/AUTO_Renderingtheform.pdf?Username='MM_UserSession'+Pwd='MM_PWDSession'

at this point the PDF should be populated automatically by reading the MS Access Data present on the Server. The things which I would like to do are:

1. Connecting the *.xdp form on the Server by changing the Connection String (probabily my Provider can help me...)

2. Filtering through the SQL string like as, finally:

WHERE Username = 'User_Session' AND Pwd = 'Pwd_User' to obtain the right binding. Do I Should use File>Properties>Variables Tool or writing directly this filter into the SQL statement ? Thanks in advance to Someone can help me (I'm newbie)

[Jared_Langdon]

Hi Massimo,



Populating forms with data on the server (unless you're very clever and a bit sneaky) requires Adobe LiveCycle Forms. If you have that product, then I suggest you post your query in that forum.



Jared

[Former Community Member]

Have a look at http://www.dtp-tjanst.com/Acrobat/PreLoad/PreLoad3.pdf

It is in swedish but Ärendenummer=Case number (used for select)

Hämta = Collect, Spara = Save, Ta bort = Delete record.

This is done with ASP conecting to a SQL server on the server.

It can be done with an mdb.

/Ulf