MicroSoft Access Data Connection Security

[Glen Stinson]

Hello,

I'm having challenges figuring out how to change the password associated
with an Access DB data connection integrated into an InfoPath form.

The form was orginally created based on a data connection with MS Access and
in the process, authentication for the data connection was specified to use a
certain user account in Active Directory, as opposed to the default setting.
This was set via the "Advanced --> Default Authorization" section of the ODBC
data connection setup wizard.

If you're curious why this was done, it allows for restricted access to the
Access DB by using a service account. The alternative would have been to
allow all users of the form to have read access to said database, which
wasn't acceptable.

Regardless, now that the form has been in use for some time, the password on
the service/AD account needs to be changed per security policy. I do not see
any options in the form design to modify the login information for the
database connection. Since the form is built around said data connection, I
don't think it's feasible to build a new data connection into the form to
allow me to update the password.

Thanks in advance for any help!

-Glen

 

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

I haven't tried this myself, but here are 2 suggestions...

Have you already tried modifying the password through the ODBC Data Source
Administrator (Start > Run > odbcad32.exe)? If a DSN was used when the form
template was created, you should be able to change the password on that same
DSN.

If the password was stored in the form template itself, you can "decompose"
the form template (File > Save As Source Files), then open the manifest.xsf
in Notepad, lookup and change the password in there, save your changes, open
the manifest.xsf in Design mode in InfoPath, and republish the form template.

 

[Glen Stinson]

A DSN may have been used, but it was likely just a one-off data connection
for this form via ODBC. I reviewed the manifest file, but didn't see any
password info. Here's the line that I feel is most relevant, in case it
helps:

<xsf:adoAdapter connectionString="Provider=MSDASQL.1;Persist Security
Info=True;Extended Properties="DSN=MS Access
Database;DBQ=\\<removed>\<removed>\<removed>.mdb;DefaultDir=\\<removed>\<removed>;DriverId=25;FIL=MS
Access;MaxBufferSize=2048;PageTimeout=5;";Initial
Catalog=\\<removed>\<removed>\<removed>" commandText="select
[PlanID],[Person_ID],[Email_Address],[Owner_Name],[WorkState],[Network_Account],[PlanType],[PlanCode]
from [qry_MakeSecurityGroup] as [qry_MakeSecurityGroup]" queryAllowed="yes"
name="qry_MakeSecurityGroup_Prod"></xsf:adoAdapter>

Thanks,
Glen