I've recently delved into Adobe LC Designer ES in order to utilize the DataConnection feature. I have successfully created my DataConnection along with buttons that will cycle through the records housed in the sheet I'm referencing without much of an issue, however I need other PCs to be able to access the same data as well.
The FormCalc code I'm using for the buttons "on Click" is:
These buttons work just fine as long as I'm accessing the form from the computer with the SQLExpress server and Designer, however once I send the PDF or access it over the network users can no longer use the buttons.
Am I overstepping the functionality of LC Designer or am I missing something even more basic like a SQL app on the client PC to connect to the SQL database that I'm referencing, or does that computer need Designer as well? I know almost nothing about SQL, so it's a miracle that I've even gotten this far. 😞
Thanks for the help guys. I went ahead and created the DSN on another PC (and learned that it has to be named exactly the same!), however I found that my main issue was that the PC's only had Adobe Reader and not Pro. So after downloading the trial I was able to get it working without a problem.