InfoPath 2007 and Access 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BenRatty - 31 Jan 2007 22:37 GMT

I cannot seem to connect InfoPath 2007 to any database created using Access
2007 even if it is saved in the 2002 - 2003 format. I can still connect to
databases created using Access 2000/2003 using InfoPath 2007 but not
databases created with Access 2007.

Anyone have any ideas. The error message I get is that I must connect to a
Microsoft SQL Server Database yet the dialog box shown asks me to select a
Microsoft Access database or Microsoft SQL server database.

Reply to this Message

S.Y.M. Wong-A-Ton - 01 Feb 2007 08:44 GMT

Are you using the RTM version of InfoPath 2007? Or a beta version? It works
in the RTM.
---
S.Y.M. Wong-A-Ton

> I cannot seem to connect InfoPath 2007 to any database created using Access
> 2007 even if it is saved in the 2002 - 2003 format. I can still connect to
[quoted text clipped - 4 lines]
> Microsoft SQL Server Database yet the dialog box shown asks me to select a
> Microsoft Access database or Microsoft SQL server database.

Reply to this Message

S.Y.M. Wong-A-Ton - 10 Feb 2007 08:12 GMT

If you created a form and checked "Enable browser-compatible features only",
you will not be able to create a data connection to an Access database, only
to a SQL Server database. Browser-compatible forms are not allowed to have
data connections to Access databases.

If you created a form and cleared the "Enable browser-compatible features
only" checkbox, you will be able to create a data connection to both an
Access and SQL Server database.
---
S.Y.M. Wong-A-Ton

Reply to this Message

Renee - 02 Mar 2007 19:06 GMT

I am having a similar problem...your answer states "if you created a form..."
i have simply opened Infopath 2007, selected databased as the type to based
my form on, and thats where i get the error . I havent yet selected the
"enable browser compatablity".

any ideas?

Signature

Renee
MSP Server Admin

> If you created a form and checked "Enable browser-compatible features only",
> you will not be able to create a data connection to an Access database, only
[quoted text clipped - 16 lines]
> > Microsoft SQL Server Database yet the dialog box shown asks me to select a
> > Microsoft Access database or Microsoft SQL server database.

Reply to this Message

S.Y.M. Wong-A-Ton - 02 Mar 2007 23:14 GMT

Can you go to the About box in InfoPath and tell me what version is listed
there? And can you please list step-by-step what actions you're taking to
arrive at the error? I need to be able to reproduce it myself, otherwise I
cannot report it as a bug to Microsoft. Up until now, I have not encountered
the error you are reporting, so the more information you can give me, the
better.
---
S.Y.M. Wong-A-Ton

> I am having a similar problem...your answer states "if you created a form..."
> i have simply opened Infopath 2007, selected databased as the type to based
[quoted text clipped - 23 lines]
> > > Microsoft SQL Server Database yet the dialog box shown asks me to select a
> > > Microsoft Access database or Microsoft SQL server database.

Reply to this Message

mattvalencia@gmail.com - 18 Mar 2007 12:51 GMT

On Mar 3, 9:14 am, S.Y.M. Wong-A-Ton
<SYMWongA...@discussions.microsoft.com> wrote:

> Can you go to the About box in InfoPath and tell me what version is listed
> there? And can you please list step-by-step what actions you're taking to
[quoted text clipped - 35 lines]
> > > > Microsoft SQL Server Database yet the dialog box shown asks me to select a
> > > > Microsoft Access database or Microsoft SQL server database.

Reply to this Message

mattvalencia@gmail.com - 18 Mar 2007 12:51 GMT

OH MY!!!!!!!!!!!!!!! I HAVE SPENT 4 hours trying to figure this out..
the error in infopath told me nothing except "nah"
This is one of the main reasons I am starting to dislike microsoft
more and more. searched their website and the help is either
elementary or advanced stuff talking about vb script etc..
I don't know about you guys, but I DO NOT HAVE TIME sometimes to go to
ms school and get my mcse to use their products. I just need to get in
and get it to work. one thing that really irritates me as well is
there is NO option for mysql.
if microsoft was committed to their clients, the option would be
there. but it is obvious they want everyone to conform and use sql or
sharepointwhatever.

> I am having a similar problem...your answer states "if you created a form..."
> i have simply opened Infopath 2007, selected databased as the type to based
[quoted text clipped - 26 lines]
> > > Microsoft SQL Server Database yet the dialog box shown asks me to select a
> > > Microsoft Access database or Microsoft SQL server database.

Reply to this Message