Daniel, DAO does not time out it's connections. However ISS does IIRC. Perhaps this is the problem.
You should be closing the DAO connection to the database when the task is completed, and opening it again when their is more work to be done. Matt ----- Original Message ----- From: "Daniel Magliola" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, June 02, 2004 1:47 AM Subject: RE: [vbhelp] Strange DAO error in ASP > Matt, > > Thanks for your answer > It is not a problem of security... > The first person to open the connection does not have a problem. It's > usually the first person to use the database after a long time of inactivity > with the connection open. > The user that opens the connection is always the same, it's the one > configured in IIS. > > I think the problem has to do with some kind of time-out in DAO/Jet > connections. > Any other ideas? > > Thanks Again > Daniel > > > -----Mensaje original----- > > De: Unicorn.PC.Support [mailto:[EMAIL PROTECTED] > > Enviado el: Monday, May 31, 2004 21:19 > > Para: [EMAIL PROTECTED] > > Asunto: Re: [vbhelp] Strange DAO error in ASP > > > > > > Daniel, I think that the clue here is '(it's usually the first > > one in that > > day, or when I try to log on during the weekend)' > > > > DAO, and ADO and any method of accessing an MDB that I know off requires > > that the first person to access the database has create access to > > the folder > > in which the database resides. This is so that the locking (LDB) file can > > be written. > > > > I would suggest that the account being used to open the database > > connection > > does not have create access to this folder. > > > > You say that a restart of ISS fixes the problem, but is that > > because ISS has > > a problem, or a different security access is being used to open the file > > after the ISS restart. > > > > Matt > > > > > > > > > > > > '// ======================================================= > > Rules : http://ReliableAnswers.com/List/Rules.asp > > Home : http://groups.yahoo.com/group/vbHelp/ > > ======================================================= > > Post : [EMAIL PROTECTED] > > Join : [EMAIL PROTECTED] > > Leave : [EMAIL PROTECTED] > > '// ======================================================= > > > > Yahoo! Groups Links > > > > > > > > > > > > > > > > > > '// ======================================================= > Rules : http://ReliableAnswers.com/List/Rules.asp > Home : http://groups.yahoo.com/group/vbHelp/ > ======================================================= > Post : [EMAIL PROTECTED] > Join : [EMAIL PROTECTED] > Leave : [EMAIL PROTECTED] > '// ======================================================= > > Yahoo! Groups Links > > > > > ------------------------ Yahoo! Groups Sponsor --------------------~--> Yahoo! Domains - Claim yours for only $14.70 http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> '// ======================================================= Rules : http://ReliableAnswers.com/List/Rules.asp Home : http://groups.yahoo.com/group/vbHelp/ ======================================================= Post : [EMAIL PROTECTED] Join : [EMAIL PROTECTED] Leave : [EMAIL PROTECTED] '// ======================================================= Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/vbhelp/ <*> 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/
