Hi Noel, MS Access does make a poor database for web-applications, and lowering your datasourcelife timeout setting is probably the most obvious solution - but you may experience slower performance because of this change.
Until you can upgrade to a more robust database, maybe try having your ASP app make a "copy" of the Access file first locally on the Server, then download the copy. Most of the time MS Access doesn't mind being copied while open - then you can do what you want to the copy. Hope this helps. Cheers..... Scott Cadillac, Witango.org - http://witango.org 403-281-6090 - [EMAIL PROTECTED] -- Information for the Witango Developer Community --------------------- XML-Extranet - http://xml-extra.net 403-281-6090 - [EMAIL PROTECTED] -- Well-formed Development (for hire) --------------------- > -----Original Message----- > From: Rick Sanders [mailto:[EMAIL PROTECTED] > Sent: Monday, July 07, 2003 1:00 PM > To: [EMAIL PROTECTED] > Subject: Re: Witango-Talk: Re: failure delivery > > > Hello, > > Yes, the setting is in your datasourcelife timeout setting. > > The default is 30 minutes, however you can change it to time out > immediately. > > If you can do it, I'd change databases to MS SQL server, > Pervasive SQL, or > MYSQL. These databases are multi-threaded, and allow for many > users at one > to access a database table. > > Rick Sanders > > ----- Original Message ----- > From: "noel estabrook" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, July 07, 2003 2:46 PM > Subject: Witango-Talk: Re: failure delivery > > > > I have a web site with some MS Access backend databases. > Most of the > > site is done in Witango, but there is some ASP on the site as well. > > The problem I'm running into is when my witango tafs do a query on > > the database, a lock file is created (W2K). When my asp > code is then > > used to grab a copy of the database, I get a File not Found error on > > the web site because the lock file is preventing it from being read. > > > > Is there any way to get Tango to release the database after its > > query? > > > > __________________________________ > > Do you Yahoo!? > > SBC Yahoo! DSL - Now only $29.95 per month! > > http://sbc.yahoo.com > > > ______________________________________________________________ > __________ > > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > > > > > ______________________________________________________________ > __________ > TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf > ________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
