Nigel, thanks but too much work right now so Jake...

Good questions. It's been YEARS since I've used Access with any proficiency
so bear with me. I'm currently using MS Access 2002, SP-2, on XP.
Yes, single user...how would I change this?
The only modification I made to the query was change the network drive path
into a UNC path.

Toby

"Jake Marx" wrote in message
...
Hi Toby,

This isn't the way it's supposed to work (at least I have never run into
this before). Do you have your MDB set up as a single-user database (set to
open exclusively)? What exact steps did you take to set up the database
query?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com