John
You'll need a "database link" set up. One for your dba I would imagine. Matt From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of John Kelley Sent: 16 April 2009 22:14 To: [email protected] Subject: SQL statement Need a little help with an SQL statement. I am trying to populate fields in INC management from an Access Database on a shared network drive. My set field SQL statement so far is : SELECT * FROM File: //usranfb/transfer/Shopinfo/shopdetail.mdb WHERE SHOP_PFCNTR = $Shop number$ When I populate the shop number in my INC I get the following error. "ARERR [552] Failure during SQL operation to the database : ORA-00903: invalid table name" I don't think it knows where the location is. Help ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
