-
I think if you go into the data connection wizard to modify the connection and select Change Database you can create a new connection to the same database but enter your SQL Auth info.
-
I am guessing you installed InfoPath on your machine. InfoPath installation includes InfoPath Designer and InfoPath Filler. If I recall correctly, at one point it was possible to install these separately, but yes, in general, your users will have to have InfoPath installed unless you intend to use InfoPath Forms Services (i.e. allow InfoPath forms ...
-
If your form users have InfoPath Filler installed, you can publish to a network location: https://support.microsoft.com/en-us/office/publish-a-form-template-to-a-shared-network-location-d069e3a0-8acd-4f8c-a560-6ba7515a203d
-
If you want to use the form as a browser form in SharePoint, InfoPath Forms Services needs to be configured in Central Admin - so you'd need to be a farm admin or have a farm admin configure it. This post refers to SharePoint 2016, but the settings are in the same place in older versions of SharePoint: ...
-
I'm glad you had a backup to work from and that it is now behaving itself!
-
Here's a copy of the form that I changed.
-
Weird - it worked for me - screenshot attached. I'll post the template where I made these changes next.
-
Save the form template as source files - you can do that from the Publish menu. Then, open the file named manifest.xsf in a text editor.
I'd probably search for:
xsf:xmlToEdit name="ProjectNo_x002e__7116"
This text is on line 1397 in the copy of the form I have.
I'd delete the maxLength attribute from this ...
-
You might try using data > refresh fields to align the form with the list schema - see attached screenshot. The first shows where to find that. I found in the manifest of your form the maxlength setting for the field is currently "3" - and I think that may be fixed if you refresh the fields. If not, I can tell you how to change that ...
-
Yeah, that's a weird one. Did you actually check the list setting character limit in SharePoint? If not, can you do that, please?