Hooray - SORTED!!!!

I delved around in the trace logs and everyone but still no joy. However, today I was looking again in the Enterprise Manager and noticed my database...

Sorry Damon - was typing in a hurry.

I meant the DBCC CHECKDB bit.

I have done some tracing and couldn't see anything odd - but will try again as soon as...

Thanks again - and will look closer at suggestion 1. I noticed suggestion 2 on other blogs, but wasn't clear how to run that???

Pete

Thanks Damon

Did the relinking and compact/repair but no change.

Not sure about the ADO bit you mention - is that relevant if I'm using DAO instead? 🙂

Did a lot of searching...

Thanks Damon - really good input.

I've browsed most of the logs looking for anything new that's been reported between last Friday when it was working and Monday when it wasn't,...

Thanks very much for your replies.

Minaz - I'd seen that too, but my Access help tells me that if I'm using a .mdb database (as I am) then a DAO...

Hi - thanks for the speedy response - I really appreciate it.

I've extracted the error message plus the contents of the last 2 error logs into the attached Word document....