Error in Connect Access Database

[Thomas Tsang]

I am using ASP + IIS + MS access, when running the
following codes:

set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
conn.open "DRIVER={Microsoft Access Driver
(*.mdb)}; " & Server.MapPath("db.mdb")

The following erorr is show:
General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x508
Thread 0x634 DBC 0x2181024 Jet'.

I have shared the MS knowledge base and try to
grant the modify Permissions to IUSR_SERVER on the
folder that holding the database, and set the
script authority in IIS, the error is still exist.
If I create a system DNS for that Access file and
modify the second code as

conn.Open "AKmobile"

Another error is show:
[Microsoft][ODBC Microsoft Access Driver] The
Microsoft Jet database engine cannot open the file
'(unknown)'. It is already opened exclusively by
another user, or you need permission to view its
data.

But there is no problem when conencting with MS
SQL Server.

Please help. Thnak a lot.

[Bob Barrows [MVP]]

Thomas Tsang wrote:

I am using ASP + IIS + MS access, when running the
following codes:

set Conn=Server.CREATEOBJECT("ADODB.CONNECTION")
conn.open "DRIVER={Microsoft Access Driver
(*.mdb)}; " & Server.MapPath("db.mdb")
Change your connection string to :

dim sConnect
sConnect = "Provider=microsoft.jet.oledb.4.0;" & _
"Data Source=" & Server.MapPath("db.mdb")
conn.open sConnect

The native OLEDB provider needs no access to the Registry. Using the
obsolete ODBC driver can lead to this error.
The following erorr is show:
General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x508
Thread 0x634 DBC 0x2181024 Jet'.
Another error is show:
[Microsoft][ODBC Microsoft Access Driver] The
Microsoft Jet database engine cannot open the file
'(unknown)'. It is already opened exclusively by
another user, or you need permission to view its
data.

The IUSR account needs read/write permissions for the FOLDER containing the
database, not just the database. All database users must be able to create,
modify and delete the locking file (db.ldb) in order for multiuser activity
to be allowed.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"

[Thomas Tsang]

Thank you for your information, but 'Unspecified
error' is show when using
sConnect = "Provider=microsoft.jet.oledb.4.0;" &
"Data Source=" & Server.MapPath("db.mdb")
conn.open sConnect

And in fact I have already grant the full control
authority to the IUSR on the folder containing the
Access database, but still failure....
"Bob Barrows [MVP]" <re******@NOyahoo.SPAMcom> ¦b
¶l¥ó news:%2****************@TK2MSFTNGP09.phx.gbl
¤¤¼¶¼g...

Thomas Tsang wrote:

I am using ASP + IIS + MS access, when running the following codes:

set Conn=Server.CREATEOBJECT("ADODB.CONNECTION") conn.open "DRIVER={Microsoft Access Driver
(*.mdb)}; " & Server.MapPath("db.mdb")
Change your connection string to :

dim sConnect
sConnect = "Provider=microsoft.jet.oledb.4.0;" &

_ "Data Source=" & Server.MapPath("db.mdb")
conn.open sConnect

The native OLEDB provider needs no access to the Registry. Using the obsolete ODBC driver can lead to this error.

The following erorr is show:
General error Unable to open registry key
'Temporary (volatile) Jet DSN for process 0x508 Thread 0x634 DBC 0x2181024 Jet'.
Another error is show:
[Microsoft][ODBC Microsoft Access Driver] The
Microsoft Jet database engine cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data.

The IUSR account needs read/write permissions

for the FOLDER containing the database, not just the database. All database users must be able to create, modify and delete the locking file (db.ldb) in order for multiuser activity to be allowed.

Bob Barrows
--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I don't check it very often. If you must reply off-line, then remove the "NO SPAM"

[Bob Barrows [MVP]]

Thomas Tsang wrote:

Thank you for your information, but 'Unspecified
error' is show when using
sConnect = "Provider=microsoft.jet.oledb.4.0;" &
"Data Source=" & Server.MapPath("db.mdb")
conn.open sConnect

You need to reinstall or install a later version of MDAC. Go to
msdn.microsoft.com and search for the latest MDAC.

Be sure to download and install the Jet components which are not included
with the MDAC installation.

Bob Barrows

--
Microsoft MVP - ASP/ASP.NET
Please reply to the newsgroup. This email account is my spam trap so I
don't check it very often. If you must reply off-line, then remove the
"NO SPAM"