Can I start by saying I'm new to this (so excuse the obvious questions please!).
I am trying to create a simple form connected to an Access DB (single table with ID and Company fields - told you it was simple). I have followed the instructions, created the form selecting Form Template and Database as the connection type.
I have then dropped ID in the query box and the Company field into the datafield box. When I try to preview the form I get a dialog box telling me:
The query cannot be run for the following DataObject: Main connection
InfoPath cannot run the specified query.
InfoPath cannot connect to the data source.
Access is denied.
Access is denied.
I have connected to the same data source in Excel to validate that it works and I get the correct data in the spreadsheet.... What am I doing wrong please?
Thanks in anticipation for you help and patience.