Date:         Wed, 7 Sep 2011 21:12:10 -0400
Reply-To:     Richard <r.hockey@SPH.UQ.EDU.AU>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Richard <r.hockey@SPH.UQ.EDU.AU>
Subject:      Re: PC File Server failure
Content-Type: text/plain; charset=ISO-8859-1

If the access db is local you can use the autostart facility see:
http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#n136kp4vncsrl8n1xmgwvwhricrw.htm

You may have to use the \\hostname\....l  format to locate the file is its
on a network.
Also some have got mileage out of removing blanks from file and path names.
R

On Wed, 7 Sep 2011 08:12:59 +0200, Keith Larson <keith.larson@BIOL.LU.SE> wrote:

>Dear list,
>
>I thought I would rephrase my question. I have a Windows 7 64x machine
>running SAS 9.2 64x and I DID download and install PC File Server. How
>can I test that it is working properly? When I run it I get no error
>messages, but I do get the following error message when I run the
>following code to import data from MS Access 2003.
>
>proc import
>       dbms = accesscs
>       out = work.WW_Site_Locations replace
>       table = 'Site_Locations';
>       database = 'Z:\Projects\Lund\Willow Warblers\Data\Willow
>Warbler Database.mdb';
>run;
>
>The results:
>
>ERROR: Failed to connect to the Server: .
>
>**************************************
>Keith Larson, PhD Student
>Evolutionary Ecology, Lund University
>S�lvegatan 37
>223 62 LUND
>Sweden
>Phone: +46 (0)46 2229014
>Mobile: +46 (0)73 0465016
>Fax: +46 (0)46 2224716
>Skype: sternacaspia
>FB: keith.w.larson@gmail.com
>**************************************