hello.<br /><br />i was asked to look into connecting a database (MS Access) to a drop downlist in a pdf form. i have never touched any pdf creation stuff prior to this. <br /><br />first issue: <br /><br />** when i try to create a data connection with "Microsoft OLE DB Provider for ODBC Drivers" i can almost create the connection, but when i get to choosing the table, a dialog pops up saying it "Could not open table".<br /><br />** if i create a dsn (which is NOT what we want in the end - but did it for a test), i also get the "Could not open table" error.<br /><br />** sooooo ... i created a connection using "Microsoft Jet 4.0 OLE DB Provider". This lets me fully create the connection.<br /><br />** QUESTION: why can't i create the connection with OLE DB Provider? Why does the JET provider work?<br /><br />-----------------------<br />second issue (and this is the biggie):<br /><br />** when i add a drop down list to my pdf form, i cannot get anything to show up in the list no matter what i try. the most recent attempts have actually given me error messages "Connection for <my connection> failed because the environment is not trusted". <br /><br />** okay, fine, how do i make it trusted?<br /><br />** how do i get this software to do what i need?<br /><br />even just a simple form with one drop down list will not connect to my data connection. it feels like i have missed some kind of security config or permissions.<br /><br />any help would be appreciated.
