I cannot connect to my Access data source

[Not a programmer!]

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?

 

[Clay Fox]

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.

 

[Not a programmer!]

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

 

[dsnybnd]

I have noticed two different threads regarding an inability to attach to a
database. When I had that problem, I started a whole new form, etc. Turns
out I just needed a primary key (I don't remember if I had to 'modify' the
data connection after adding the primary key). For future readers, try that
first.