Re: Connection to Access DB

Clay Fox — Tue, 08 Jul 2008 16:29:22 GMT

Where is the Acces DB located?

I would first try running through the data connection wizard again.

Highlight main, select modify and run through the windows and see if it continues.

Connection to Access DB

NeilQ — Tue, 08 Jul 2008 09:00:31 GMT

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.

Data Connections

Re: Connection to Access DB

Connection to Access DB