Date:         Thu, 22 Jul 2004 12:45:14 -0400
Reply-To:     bill_droogendyk@DOFASCO.CA
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         Bill Droogendyk <bill_droogendyk@DOFASCO.CA>
Subject:      Re: Proc Export to MS Access
Content-Type: text/plain; charset="us-ascii"

Thanks to Paul Choate.

Both solutions work, i.e dropping the workgrp path (which the wizard
asks you specify) or adding all 3 of dbpwd, pwd, uid.

wd
Today's gift is ... Today!


-----Original Message-----
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of
Choate, Paul@DDS
Sent: 22 July, 2004 12:30
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: Proc Export to MS Access


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!