SQL Server Only Data Connections

[JohnL]

We have 2 computers running the same infopath 2007 build with the same
service pack 2 on XP Pro SP3 machines. In the data connections section 1 of
these machines says Databases(SQL Server and Access databases only) while the
other says Databases(SQL Server Only). We have created several forms with
Access DB connections from the 1st machine, but as the 2nd one says, it will
not allow a connection to a Access database. Any idea what the difference is
between these installs?

Thanks in advance

 

[S.Y.M. Wong-A-Ton]

It does not have to do with your install, but with the compatibility your
InfoPath form template is set to (see Tools > Form Options > Compatibility).

If you're designing an InfoPath form template that can be filled out only
with the InfoPath client application, you'll see "Microsoft SQL Server or
Microsoft Office Access only" in the Data Connection Wizard.

If you're designing an InfoPath form template that can be filled out with
the InfoPath client application or through a browser, you'll see "Microsoft
SQL Server only" in the Data Connection Wizard.