If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Data provider could not be initialized"?
I have almost an identical problem to the following threads (none seem to be
resolved): http://www.experts-exchange.com/Web/...rTAFilter=true http://www.experts-exchange.com/Data...rTAFilter=true http://www.experts-exchange.com/Data...rTAFilter=true http://www.experts-exchange.com/Data...rTAFilter=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 |
#2
|
|||
|
|||
Sorry for the duplicate posts. I got an error saying try try again.
"Steve" wrote: I have almost an identical problem to the following threads (none seem to be resolved): http://www.experts-exchange.com/Web/...rTAFilter=true http://www.experts-exchange.com/Data...rTAFilter=true http://www.experts-exchange.com/Data...rTAFilter=true http://www.experts-exchange.com/Data...rTAFilter=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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
"Data provider could not be initialized"? | Steve | General Discussion | 2 | October 13th, 2004 11:12 AM |
Images in a database | Franz | General Discussion | 10 | October 7th, 2004 09:35 AM |
Is this possible with Excel Chart? | q582gmzhi | Charts and Charting | 1 | September 8th, 2004 03:33 AM |
Using Queried Data alongside Manually entered data | gwrose | General Discussion | 1 | July 23rd, 2004 04:45 AM |
Problems with converting data held in an Excel spreadsheet to Word | mark Gray | Mailmerge | 6 | July 8th, 2004 10:54 AM |