InfoPath does not support the specified database. The database must be a Microsoft SQL Server

Applies to: InfoPath 2007

Learn how to solve the InfoPath error: InfoPath does not support the specified database. The database must be a Microsoft SQL Server.

ADVERTISEMENTS

Problem

In InfoPath 2007, you get the following error message when you try to design a form template that is based on a Microsoft Access database:

InfoPath does not support the specified database. The database must be a Microsoft SQL Server

Solution

On the Design a Form Template dialog box, uncheck the Enable browser-compatible features only checkbox before selecting Database, clicking OK, and then selecting your Microsoft Access database.

Discussion

A Microsoft Access database cannot be used as the Main data source of an InfoPath browser-compatible form template.

While you can base a browser-compatible form template on a Microsoft SQL Server database, you will not be able to submit data to the database, because Submitting to a database is not supported in browser-enabled form templates.

If you base your browser-compatible form template on an SQL Server database, you will only be able to retrieve data through the Main data connection of the form template.

 


Related InfoPath Articles:

 

Copyright: This article may not be used on web sites (whether personal or otherwise), copied, disseminated, altered, printed, published, broadcasted, or reproduced in any way without an expressed written consent. The techniques demonstrated in this article may be used within any Microsoft InfoPath project. This article is provided without any warranties. Copyright for this article is non-transferrable and remains with the author.

InfoPath 2013 Cookbook: 121 Codeless Recipes for Beginners

InfoPath 2013 Cookbook 2: 121 Codeless Recipes for SharePoint 2013

InfoPath 2010 Cookbook: 101 Codeless Recipes for Beginners

InfoPath 2010 Cookbook 2: 101 Codeless Recipes for SharePoint 2010

InfoPath 2010 Cookbook 3: 101 Code Recipes for C# Developers

InfoPath 2010 Cookbook 4: 101 Code Recipes for VB Developers

InfoPath 2010 Cookbook 5: Integrating InfoPath with Excel and Excel Services