Error in Connect Access Database

T

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.
 
B

Bob Barrows [MVP]

Thomas said:
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
 
T

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]" <[email protected]> ¦b
¶l¥ó ¤¤¼¶¼g...
Thomas said:
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"
 
B

Bob Barrows [MVP]

Thomas said:
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
 

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

Members online

Forum statistics

Threads
473,744
Messages
2,569,484
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top