InfoPath Dev

My forms and database are published to a shared folder on a network.
I set up a password to MS Access yesterday to secure the database.

However, whenever a user open IP, it asks for password. And my managers doesn't want this. They want to end users open the froms without entering the password.

Therefore, I tried to modify the dataconnection in IP, but it pops out a dialog "Please Enter MS JET OLE DB Initialization Information."
After I entered the password, I was still unable to open the database.

How can I resolve this issue?

Hey troy0118,

You should be able to store the password in the data connection - I think there is a checkbox to make it do this. However, this is insecure. If you switch to SQL Server (instead of Access) you can use our DBXL product to pull rows out of the database through a web service which means that there will be no security breaches.

Check out the free developer download:http://www.qdabra.com/proddetail.asp?prod=QDBXL1

Your suggestion sounds good, and I will recommend to my supervisor.
However, right now we have to get this done.
I am sorry to say so, but there is no any checkbox in the dialog.

Please advice.