B
BethB
I need to connect an infopath form to an access database that has been
secured using the Security Wizard. I have been able to set up the data
connection by choosing the Microsoft Jet 4.0 OLE DB Provider and specified
the path to the workgroup file by editing the value of Jet OLEDB:System
database on the All tab. I also wish to not save the username or password
which I strip out on the same tab.
When I try to save the connection it prompts me for a username and password
and saves the username with the connection. Is there a way around this?
I need each user to have to supply their own username and password when they
submit the infopath form, but since the username is saved, the user is only
prompted for a password.
I do grab the network username of the user and populate a field on the form
with it, but cannot figure out how to use this in place of the username that
infopath is trying to use to submit since I cannot write code that runs when
the submit event occurs. (Or can I?)
Thanks...Beth
secured using the Security Wizard. I have been able to set up the data
connection by choosing the Microsoft Jet 4.0 OLE DB Provider and specified
the path to the workgroup file by editing the value of Jet OLEDB:System
database on the All tab. I also wish to not save the username or password
which I strip out on the same tab.
When I try to save the connection it prompts me for a username and password
and saves the username with the connection. Is there a way around this?
I need each user to have to supply their own username and password when they
submit the infopath form, but since the username is saved, the user is only
prompted for a password.
I do grab the network username of the user and populate a field on the form
with it, but cannot figure out how to use this in place of the username that
infopath is trying to use to submit since I cannot write code that runs when
the submit event occurs. (Or can I?)
Thanks...Beth