Database Connection Error

[ridawg]

Hey,

I'm getting the following error on a dropdown list that is populated by a
table in Access (this connection is not my main connection).

Form template: file:///\\[directory path]/my_form.xsn

The following DataObject either cannot be created or cannot be initialized:
Location_Number_Lookup

The query cannot be run for the following DataObject: Location_Number_Lookup

InfoPath cannot run the specified query.

InfoPath cannot connect to the data source.

The Microsoft Jet database engine cannot open the file [directory
path]\my_db.mdb'. It is already opened exclusively by another user, or you
need permission to view its data.

Any help would be greatly appreciated!

 

[ridawg]

Hey,

I've made some progress on this error and wanted to share what I've found out.

I'm not sure why this is but the database connection info in the .xsn file
is different than the connection info in the .odc file that InfoPath creates.
My problem I believe is related to the Open Mode. In the .xsn file teh Open
Mode = ReadWrite and in the .odc file the Open Mode = Share Deny None.

This is the scenario I have so if anyone can give me advice on the security
or open mode settings I should be using that would be great.

1. I have database that is connected to my InfoPath form and is located in a
different folder than the InfoPath form. The users have Read and Read &
Execute permissions (file security settings) to both the database and
InfoPath form.

2. I went into the .xsn file and changed the open mode settings to Share
Deny None. Same settings as the .odc files.

My goal is to allow the users to use my InfoPath form to query the database
and have the appropriate data returned but to not allow them direct access to
the database. The purpose of the form is to get the data not to make any
changes to it.

Also - is it normal for the open mode settings to be different in the .xsn
and .odc files. I thought this was odd.

Thanks!