b_v_annadurai@hotmail.com

Dear sir,

My ASP.NET program is running in WIN XP OS. I want access MS access database(MDB) from WINDOWS 2000 Professional OS machine, which all are under in same domain.

While running my ASP.net programming, the below error is appearing. If I try to access from WIN98, then there is no problem.

Kindly check and do the needful.

Regards

V. Annadurai

Accessing MS ACCESS database through ASP.NET 每 VS 2003

My machine OS is WIN XP service pack 2

I want open the database and copy some records from MS Access database. The MS ACCESS file (mdb) file is in another machine. If I work with local system mdb file then it is working fine. If I try to open the file from network the following error message is appearing.

The Microsoft Jet database engine cannot open the file '\\cogento\PLAT04S\Acu301.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot open the file '\\cogento\PLAT04S\Acu301.mdb'. It is already opened exclusively by another user, or you need permission to view its data.

Source Error:

Line 192:        Dim mdbcon As New OleDb.OleDbConnection(dsnmdb)
Line 193:        Dim mdbcmd As New OleDb.OleDbCommand(mdbsql, mdbcon)
Line 194:        mdbcon.Open()
Line 195:        Dim r As OleDb.OleDbDataReader = mdbcmd.ExecuteReader
Line 196:        Dim x As Integer = 0


Source File: c:\inetpub\wwwroot\payroll system\attendance_update.aspx.vb Line: 194


My coding is (while using the below command, the above error message is appearing.)

dsnmdb = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\cogento\PLAT04S\Acu301.mdb"

if I try with below coding then no problem in output.

dsnmdb = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=d:\keico\slpb\Acu301.mdb"

Kindly check and how to rectify the same.

Regards

v. annadurai




Re: Developer Documentation and Help System Accessing MS ACCESS database through ASP.NET 每 VS 2003

Noral

Hello,

BTW - This forum is for help on Developer documentation like MSDN and utilities like Sandcastle.

I believe that someone may have the table open in design mode, which would open that table exclusively or that record is being edited and has a lock on it. If you or other people accessing this DB close the design windows in Access this should fix the problem. You might want to consider using SQL Server Express Edition, Access was never meant to be used in a web world AND IT IS FREE!

Good lock, I mean luck,

Noral