access and asp.net

[phil cunningham]

I have an access database which I am using both with Access and ASP.NET

Everything is working fine except if I try to run both together.

If Access has the database open the website reports the following error

Could not use 'C:\CallidusWorld\App_Data\oakleafAccountsData.mdb'; file
already in use.

I've tried moving all stuff pertaining to ASP into a separate database with
linked tables but this made no difference

surely I should be able to run both together - is there a setting I am
missing

Hope someone can help as I am stuck

All the best
Phil

 

[TC]

Maybe the Access front end, or the ASP.NET code, or both, are trying to
open the back-end database "read only"? (Sorry I can't be more
specific. You could write what I know about ASP.NET, around the edge of
a stamp - with a blunt pencil!)

HTH,
TC (MVP Access)
http://tc2.atspace.com

 

[Arvin Meyer [MVP]]

You might want to check how each is opening the database. Make sure that the
application is split, so that only the data is on the server. That is the
case with the ASP app, but not necessarily with the Access app. I run a
total of 51 concurrent users on an Access back-end with 35 connected via the
LAN, 8 connected via an ASP (not .NET) app, and 8 connected via Terminal
Services. I rarely have locking problems.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[phil cunningham]

Arvin

thanks for the reply

I've tracked down the problem a bit further

If I restrict myself to Visual Web Developer 2005 everything works fine. It
works whether Access is open or closed

If I try to view the same pages using IIS it fails but only when Access has
the forms open

I've checked the security settings for IIS and they 'seem' OK - do you have
any ideas?

Phil

 

[Arvin Meyer [MVP]]

Check out if I_USR (the default user for IIS) is locking the file. You can
do that by going to the server, right-clicking on My Computer and choosing
Manage. Then check for open files.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access