I'm trying to connect to a database on an IIS server, NT 4.0 It is in the 
same folder as other databases that I can connect to just fine. The 
folder, and the file itself have the exact same permission my other 
databases have.  The official Microsoft diagnosis can be found here, 

http://support.microsoft.com/default.aspx?scid=KB;EN-US;q306269&

The file is not marked exclusive.
The Access database is not local.

Someone please help me!


----------ERROR MESSAGE----------------------
Microsoft JET Database Engine error '80004005' 

You do not have the necessary permissions to use 
the 'x:\xx\xxxx\xxx\xxx\xx xxxx xxx xxxx.mdb' object. Have your system 
administrator or the person who created this object establish the 
appropriate permissions for you. 

/xxxx/xxxxx.asp, line 91
--------------end--error message------------------

Line 91 is conn.open

------------------code---------------------
IP3TLDB = Server.MapPath("/xxx/xxxx/xx xxxxx xxxx xxxx.mdb")
SET conn = Server.CreateObject("ADODB.Connection")	
conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source="&IP3TLDB
conn.Open
-------------end--code---------------------

I can see several problems here, but you haven't provided enough information
to indicate which could be the cause:

a) spaces are *not* allowed in URLs. Server.Mappath() expects a URL. Spaces
need to be encoded (ie replaced with %20. Suggest you try usin
Server.URLEncode() on your *path*, then pass to Server.Mappath().

b) you don't indicate what type of user account is being used to access the
remote database. An account that is local to the webserver can not be
assigned permissions to a remote resource.

Cheers
Ken

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "Al Vazquez" <avazqu1@p...>
Subject: [access_asp] Permissions are fine, error still occuring


: I'm trying to connect to a database on an IIS server, NT 4.0 It is in the
: same folder as other databases that I can connect to just fine. The
: folder, and the file itself have the exact same permission my other
: databases have.  The official Microsoft diagnosis can be found here,
:
: http://support.microsoft.com/default.aspx?scid=KB;EN-US;q306269&
:
: The file is not marked exclusive.
: The Access database is not local.
:
: Someone please help me!
:
:
: ----------ERROR MESSAGE----------------------
: Microsoft JET Database Engine error '80004005'
:
: You do not have the necessary permissions to use
: the 'x:\xx\xxxx\xxx\xxx\xx xxxx xxx xxxx.mdb' object. Have your system
: administrator or the person who created this object establish the
: appropriate permissions for you.
:
: /xxxx/xxxxx.asp, line 91
: --------------end--error message------------------
:
: Line 91 is conn.open
:
: ------------------code---------------------
: IP3TLDB = Server.MapPath("/xxx/xxxx/xx xxxxx xxxx xxxx.mdb")
: SET conn = Server.CreateObject("ADODB.Connection")
: conn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data
: Source="&IP3TLDB
: conn.Open
: -------------end--code---------------------

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~