Couple things: a) Don't do remove .mdb file - really, bad idea. b) Any other users accessing the file on the LAN? That could cause exclusive lock c) Any kind of backups of the mdb file? That can cause exclusive lock d) are you closing the connections ALWAYS and setting the connection = nothing afterwards?
If all those then is the connection between the boxes reliable? Any reason you can't share the file the other way? Let the web server share it to the other box? Steve Radich - http://www.ASPDeveloper.Net - FREE Information Resources BitShop, Inc. - http://www.bitshop.com - Managed Servers, Colocation, .Net Development (C#,VB,ASP) -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Mingle Sent: Friday, November 18, 2005 6:28 PM To: [email protected] Subject: [AspClassicAnyQuestionIsOk] Ms Access Error Hi, I am having this Annoying problem - My ASP Application (hosted on Server A) tries to connect to MS Access Database hosted on Server B (Windows NT 4 Server), then sometimes I get this error. Microsoft JET Database Engine error '80004005' The Microsoft Jet database engine cannot open the file '\\ServerB\ACCESSDATABASE\abc.MDB'. It is already opened exclusively by another user, or you need permission to view its data. If I restart Server B where Access is hosted, then The Application is able to connect to the Database file correctly. Once the Server in restarted, it works fine but after few hours it again starts showing the Error. I have tried to search for this problem on the Internet and have found few MSDN Support Articles. I have done all the possible things, like --- giving Internet Guest User Read/Write permissions, --- creating System Variables TEMP on main Server..... --- Check DataBase File Permissions for internet guest user. --- Check C:\TEMP (System Variable location) folder's permissions. But nothing seems to work. Please help if you have enountered / or are aware of such a problem. Thanks, Mingle. [Non-text portions of this message have been removed] Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Get fast access to your favorite Yahoo! Groups. Make Yahoo! your home page http://us.click.yahoo.com/dpRU5A/wUILAA/yQLSAA/saFolB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
