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 > > > > > > ------------------------ 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/
