Access to SQL

M

Matt

Hi Folks,
If I have an InfoPath form linked to an Access database is there a way to
convert the whole thing to SQL? Thanks ahead of time!
Matt
 
F

Franck Dauché

Hi,

If you go your manifest and find the reference to your access DB:
should start by: <xsf:adoAdapter
connectionString="Provider=Microsoft.Jet.OLEDB.4.0

you need to update your connection string to connect to SQL Server.

Franck Dauché
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open form 0
Remove checked items from To Do lists 0
Export tracked changes to a new document 0
Using the list form control: multi-selection possible? 3
Sharepoint not capturing staff name when automation runs 0
InfoPath 2013 crashes when trying to connect to Access 2016 DB 0
Ranked-choice poll in Outlook? 0
Setting a default zoom in Infopath 0

Top