I have posted in an Access newsgroup, but no answer yet. You're right about
the Excel relevance - actually I'll be making the calls from Word.

Regards,
VBA Dabbler

"Tom Ogilvy" wrote:

Perhaps someone here is an expert on this, but I know I am not. I would
recommend posting in an Access newsgroup for a more definitive answer. the
only relevance to Excel is that you are doing it through Excel VBA, but that
would be true for Word, PowerPoint, VB and so forth.

--
Regards,
Tom Ogilvy

"VBA Dabbler" wrote in message
...
Tom,
Yes. However, the database is on a network share and so is the workgroup
file. I browsed your site - the closest match I found to my situation is
"If
using a Workgroup (System Database)" under "OLE DB Provider for Microsoft
Jet
". It's below:

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=c:\somepath\mydb.mdb;" & _
"Jet OLEDB:System Database=MySystem.mdw", _
"myUsername", "myPassword"

How do I point to the workgroup file? Replace the "MySystem.mdw"
reference
to the path/name combination of the workgroup file?

Thanks,

VBA Dabbler

"Tom Ogilvy" wrote:

Do you mean something like this:
Set adoConn = New ADODB.Connection
adoConn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
sAccessDB & "; USER ID=Admin; PASSWORD=abcd;"

or does the database itself have a password:



http://www.able-consulting.com/MDAC/...orMicrosoftJet

Look for the section 'If MDB has a database password'

--
Regards,
Tom Ogilvy

"VBA Dabbler" wrote in message
...
Does anyone know the syntax to establish a workspace/connection to
query
data
from an Access database that has security set up?

I've set up a special UserID and Password for this purpose.

Thanks,

VBA Dabbler