Default open mode was shared. Well, still is shared.
ODBC driver for Access.

Now, I had the db open. When I opened the workbook a very odd window popped
up:
Please Enter MS JET OLE DB Initialization Information
and it showed the data source, user name, etc., and the last item was Open
Mode: with a drop-down box. In it was selected DB_MODE_READWRITE.

Ah-soo.

So I selected DB_MODE_SHARE_DENY_NONE. Clicked OK and the data downloaded and
everything worked like it was supposed to. Here is the new output of the
connection from the "Edit OLE DB Query" from the Edit Query... menu item:

Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=\\pdxberkompas02\Reporting$\public_reportin g\Siebel_Export.mdb;Mode=Sha
re Deny None;Extended Properties="";Jet OLEDB:System database="";Jet
OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine
Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk
Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database
Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt
Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact
Without Replica Repair=False;Jet OLEDB:SFP=False

The key is "Mode=Share Deny None" in the second sentance above. Previously it
was ReadWrite (or close to that) and that, I surmise, was my problem. Now
everything is fine.

Thanks Jake for helping me along :-) Now I know how to configure my other
queries for this process.

Toby

"Jake Marx" wrote in message
...
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]