ASP.NET and MS Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been troubleshooting and troubleshooting over and
over again using MS Access in ASP.NET application. I'm
pretty sure some of you may had the same problem i'm
having but does anyone have this solution. it seem we have
permission or access locks with connect to an access
database though ASP.NET application. now, i check the
knowledge base and i follow there direction and it still
doesn't work. if any one resolved this problem, please
share your solution. this has been driving me crazy and
all of it doesn't make any since. thnx in advance!
 
what exactly is your problem?

--
Regards

John Timney (Microsoft ASP.NET MVP)
----------------------------------------------
<shameless_author_plug>
Professional .NET for Java Developers with C#
ISBN:1-861007-91-4
Professional Windows Forms
ISBN: 1861005547
Professional JSP 2nd Edition
ISBN: 1861004958
Professional JSP
ISBN: 1861003625
Beginning JSP Web Development
ISBN: 1861002092
</shameless_author_plug>
 
i get this error when connecting or updating an access
database:

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

(i get the message if i try to connect and i check for
access lock (*ldb file). there was none.

-or-

Operation must use an updateable query.
(this one didn't come up after successfully connect to the
access database.)


i follow instruction from article # 316675 but it didn't
work.
 
Do you have the database open via access when you get
this error? Close Access and try the ASP again.
 
This is almost always a permissions issue, where the asp.net account or the
autheticated user it is running as doesn't have read or write access to the
MDB file. An MDB database must be able to write the ldb file to the
directory it resides in - does the directory/web application have write
permissions.

--
Regards

John Timney (Microsoft ASP.NET MVP)
----------------------------------------------
<shameless_author_plug>
Professional .NET for Java Developers with C#
ISBN:1-861007-91-4
Professional Windows Forms
ISBN: 1861005547
Professional JSP 2nd Edition
ISBN: 1861004958
Professional JSP
ISBN: 1861003625
Beginning JSP Web Development
ISBN: 1861002092
</shameless_author_plug>
----------------------------------------------
 
¤ I have been troubleshooting and troubleshooting over and
¤ over again using MS Access in ASP.NET application. I'm
¤ pretty sure some of you may had the same problem i'm
¤ having but does anyone have this solution. it seem we have
¤ permission or access locks with connect to an access
¤ database though ASP.NET application. now, i check the
¤ knowledge base and i follow there direction and it still
¤ doesn't work. if any one resolved this problem, please
¤ share your solution. this has been driving me crazy and
¤ all of it doesn't make any since. thnx in advance!

There are two articles that cover this issue:

PRB: Cannot Connect to Access Database from ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;316675&Product=aspnet

INFO: Permissions to Connect to a Remote Access Database from ASP.NET
http://support.microsoft.com/default.aspx?scid=kb;en-us;307901&Product=aspnet


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
I GOT IT!
THANK YOU ALL!
-----Original Message-----
i get this error when connecting or updating an access
database:

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

(i get the message if i try to connect and i check for
access lock (*ldb file). there was none.

-or-

Operation must use an updateable query.
(this one didn't come up after successfully connect to the
access database.)


i follow instruction from article # 316675 but it didn't
work.

.
Click to expand...
 
Back
Top