"Data provider could not be initialized"?

S

Steve

I have almost an identical problem to the following threads (none seem to be
resolved):

http://www.experts-exchange.com/Web...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

http://www.experts-exchange.com/Dat...+could+not+be+initialized"&clearTAFilter=true

I creates a DAP using Access connecting to a mdb. All the files are located
in a folder in the inetpub directory. The DAP points to the database using
the UNC path(local path doesn't work). All this is in a virtual website in
IIS.

When my colleague or I access the DAP through iexplorer it works (much
slower for him) but, when I try to access the page from any other user
account I get:

"Data provider could not be initialized" followed by another popup saying:
"The microsoft jet database engine cannot open the file <UNC path>. It is
already opened exclusively by another user, or you need permission to view
it's data"

I'm pretty sure it's not an "in use" problem the db isn't locked and both of
us can access it in many instances at once. This leads me to focus on the
permision issue. We're the only 2 who can access it and we're both domain
admins. No other users can access it. Another problem is if we log in as THE
domain admin account we can't access it either. What's special about our 2
accounts that's preventing anyone else from accessing the page? All users
have appropriate NTFS folder/file as well as IIS permisions.

Thanks,

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top