A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

"Data provider could not be initialized"?



 
 
Thread Tools Display Modes
  #1  
Old October 12th, 2004, 08:29 PM
Steve
external usenet poster
 
Posts: n/a
Default "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  
Old October 12th, 2004, 08:31 PM
Steve
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 07:48 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.