General

Re: Strange "unable to connect to datasource" issues

stuckinoregon — Thu, 13 May 2010 16:44:27 GMT

Thanks for the reply. Yes, all of the users have full r/w access to the drive that the db and xsns reside on and they are all in the same domain. If we could have a server/client environment available, I wouldn't have ulcers and life would be rainbows and unicorns. This is inside of a VERY large corporation, so trying to justify the deployment of another server instance for our relatively small project.

Re: Strange "unable to connect to datasource" issues

Patrick Halstead — Thu, 13 May 2010 00:25:51 GMT

We use SQL databases for these kind of scenarios and have never seen this. I don't really know but here are a couple questions:

Is it always the same users or do they change?
Do the users have the same internet settings for the server that the Access MDB is on? Is it on a server in the same domain?

Strange "unable to connect to datasource" issues

stuckinoregon — Wed, 12 May 2010 21:18:48 GMT

I hope this is not one of those "Every n00b has this issue and comes in here and asks this question!" questions.

Using infopath for submitting form data to and access db. The xsn files and the database reside on the same network share and share the same rights for all users. The problem we're having is that some users can submit to the mdb just fine and others get the "unable to connect to the datasource" warning. All of the users can browse to the templates and the database. This is in a large AD governed environment but all users have been granted the same access to the share locations where the respective files reside. We have effectively ruled out AD as I am unable to submit when logged into these users' machines using my profile. Both InfoPath and Access are from Office 2007.

Any suggestions on what to look at?