I got that same types of errors after installing a service pack, and it turned out it was caused by the newer version of MSDAC or ADO or something like that that was installed by the service pack. After that, any web app that hit an Access database would work fine if I was the only one using it, but if just one other person hit it simultaneously I would get an error like the one you mentioned. Previously I was impressed by the load Access databases could handle, and then after this snafu I decided to convert all my Access apps to SQL Server. I was told that I could fix the problem by installing the right version of MSDAC or ADO or whatever it's called, but I didn't want this problem to crop up again the next time we installed a service pack or some other update.
The bottom line is that Access is not a good choice for web-database apps. Sure, it might work fine, and you can do some very impressive things with it, but there just no good reason to use it instead of SQL Server or MySQL. ...just my two cents. > -----Original Message----- > From: kpraoasp [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 07, 2004 1:44 PM > To: [EMAIL PROTECTED] > Subject: [ASP] IIS 6.0 problem. > > > > Hi All, > > I recently installed IIS 6.0 and moved all my active server > pages there. I am able to get in into the website but when > some other people try to get in, it says that the page cannot > be displayed. > It's very random. Does it have to do with the network or i > need to check my IIS settings. > > One thing I noticed is I got this error on some machines > Microsfot OLE DB Provider for ODBC Drivers error '80004005' > Could not use unknown; file aleady in use. In the default > page, this is the place where i get the error conn.Mode = 3 > conn.Open Application("cnIntranet_ConnectionString"), > Application("cnIntranet_RuntimeUserName"), Application > ("cnIntranet_RuntimePassword") > > And all the application variables are defined in global.asa > in the home directory.. I dont know whether these two are connected. > > Thanks, > KP > > > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > $4.98 domain names from Yahoo!. Register anything. > http://us.click.yahoo.com/Q7_YsB/neXJAA/yQLSAA/17folB/TM > -------------------------------------------------------------- > ------~-> > > -------------------------------------------------------------- > ------- > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [EMAIL PROTECTED] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > Yahoo! Groups Links > > > > > > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> 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/
