Hi Toby,

Toby Erkson wrote:
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?

Tools | Options, Advanced tab...look under Default open mode.

The only modification I made to the query was change the network
drive path into a UNC path.

So you created the query using the Query Wizard, right? What did you select
as the data source? The ODBC driver for Access, or do you have a DSN set up
already?

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]