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