The following works for SQL Server in a similar situation. Not sure
what the corollary to "OPENDATASOURCE" is for Oracle.
SELECT X.* FROM OPENDATASOURCE('Microsoft.jet.OLEDB.4.0',
'Data Source=\\usranfb\transfer\Shopinfo\shopdetail.mdb;
Jet OLEDB:Database Password=<password>;')...<table name> X
WHERE SHOP_PFCNTR = $Shop number$
<password> is an optional database level password - if there is no
database password on the .mdb file I think you can omit the entire "Jet
OLEDB:Database Password=<password>;" phrase.
<table name> is the name of the table containing the SHOP_PFCNTR field
in your Access database.
Hope this helps,
Jim.
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
