I cannot connect to my Access data source

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Not a programmer! - 07 Feb 2008 23:34 GMT

I'm just getting started trying to understand and use this program. I was
following along using the book, "Designing Forms for Microsoft Office
InfoPath and Forms Service 2007" and have run into a stumbing block. My form
has been layed out and I carefully named all my InfoPath form fields with the
same name they have in the Access database (Office 2007) that I also created.
When I then proceed to Tools, Data connections, Add, Create a new connection
to receive data , selecting database, browse to select my Access Database,
Select Table, I run into the error message "InfoPath cannot connect to the
data source". When I ask to show the details of this error message it reads:
"InfoPath does not support the specified database. The databse must be a
Microsoft SQL Server of Microsoft Office Access database (which it is!).
What am I doing wrong?

Reply to this Message

Clay Fox - 07 Feb 2008 23:53 GMT

Hey there.

Are you going to want to submit the data from your form back to Access?
If so you have to start off from scratch as a database type form.

I would try saving your database as a mdb file instead of the new 2007
extension. I think it works with either but it is worth a try.
Also you should be able to browse directly to your database file when
selecting a datasource rather then using the ODBC connections.

Lastly my advise is to use SQL Express, which is free, but a better
multiuser database platform and more capable if you need to expand your
solution down the road.

Signature

Clay Fox / Microsoft InfoPath MVP
www.InfoPathDev.com / The InfoPath Authority / Downloads, Samples, How-To,
Experts, Forum

> I'm just getting started trying to understand and use this program. I was
> following along using the book, "Designing Forms for Microsoft Office
[quoted text clipped - 8 lines]
> Microsoft SQL Server of Microsoft Office Access database (which it is!).
> What am I doing wrong?

Reply to this Message

Not a programmer! - 07 Feb 2008 23:58 GMT

Thanks for the advice. I'll try that right away.

> Hey there.
>
[quoted text clipped - 22 lines]
> > Microsoft SQL Server of Microsoft Office Access database (which it is!).
> > What am I doing wrong?

Reply to this Message