Date:         Thu, 22 Jul 2004 09:30:18 -0700
Reply-To:     "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         "Choate, Paul@DDS" <pchoate@DDS.CA.GOV>
Subject:      Re: Proc Export to MS Access
Comments: To: "bill_droogendyk@DOFASCO.CA" <bill_droogendyk@DOFASCO.CA>

Hey Bill - A stab in the dark:

Have you tried all three with double quotes?  Your DBS might be defaulting
to an UID and confusing the WGDB.

DBPWD="";
PWD="";
UID="";

Or taking off the
WORKGPDB="\\Hafs01\HACommShare\CapPlanTubes\CapPlanTubesData\INV.mdw"; ?

Hope that doesn't hurt!

Paul Choate
DDS Data Extraction
(916) 654-2160

-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Bill
Droogendyk
Sent: Thursday, July 22, 2004 9:09 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Proc Export to MS Access

Folks:

The Export Wizard built the following code for me.  It works well in
Wizard mode, but produces the security error when I try to run it in a
program.  The Access mdb has no passwords attached to it. Adding dbpwd='
'; and pwd=' '; do not make any difference.

Does anyone have any ideas?

PROC EXPORT DATA= data.INVENTORY

OUTTABLE= "SERNOF"

DBMS=ACCESS2000 REPLACE;

DATABASE="\\Hafs01\HACommShare\CapPlanTubes\CapPlanTubesData\INV.mdb";

WORKGPDB="\\Hafs01\HACommShare\CapPlanTubes\CapPlanTubesData\INV.mdw";

RUN;

ERROR: The security information supplied is incomplete. Check the usage
of PASSWORD and DBPWD.

Thanks,
wd
Today's gift is ... Today!