I have version 18.104.22.16844.1.471865. Windows XP environment.
I created a simple msAccess mdb file with no security, using Access 2002. I have successfully bound the fields in that database's single table using OLEDB Database connection. Under connection string, I selected Microsoft Office 12.0 Access Database Engine. Data source is the name and path to the local mdb file that resides on my c: drive. Access permissions are Read only, since I just want the database to populate the form, then not allow the users to change any data in these fields.
When I select PREVIEW PDF, I get the error message: Connection for SourceData Connection Failed. When I click OK, the preview continues and I see all field information correctly, as if there were no error at all.
What am I doing wrong? This error is prohibiting me from distributing the form. The form originally came from an outside source, and as I understand it was created with Acrobat Pro version 8.
Is there any script on the form that is left behind from the inherited form?
In Designer, have a look at the hierarchy view, then in the script editor change the show dropdown to Events with Scripts. Then click on the root node of your form. This will show all scripts in the form. Is there a database open command in there somewhere?
I have a static pdf that I created in LiveCycle Designer 8.2 with Data Connections to a MS Access DB for values in multiple drop-down lists. Everything works great on my computer. It also works fine when I send people my pdf. When the pdf is opened in adobe through a web browser it prompts the user to connect the the db which it cannot because it is on my computer.
I checked and there is no database open command in any Events with Scripts.
Are there any settings I can change to make this prompt not show?