I spoke too soon. The query created by the wizard does not work. It still
block me.
Need help.

thanks

"Phil Hunt" <phung1010(remove this)@hotmail.com> wrote in message
news:%23Hkgl%(E-Mail Removed)...
>I got it using the wizard.
> DELETE FROM [myTable] In 'C:\Protected.MDB' [;PWD=xxxx]
>
> "Phil Hunt" <phung1010(remove this)@hotmail.com> wrote in message
> news:(E-Mail Removed)...
>> Hi,
>> I am running a query from a MDB to delete records from a table on another
>> location.
>> The other table is password protected so it kicks out. Is there a way to
>> specify the password in this systax ?
>>
>> DELETE FROM [myTable] In 'C:\Protected.MDB'
>>
>
>

In news:e%(E-Mail Removed),
Phil Hunt <phung1010(remove this)@hotmail.com> wrote:
> I spoke too soon. The query created by the wizard does not work. It
> still block me.
> Need help.

You should be able to use either of these syntaxes:

DELETE FROM [myTable] IN "" "MS
Access;Database=C:\Protected.MDB;pwd=xxxx";

DELETE FROM [MS Access;Database=C:\Protected.MDB;pwd=xxxx].[myTable];


--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Dirk,
I don't know how you found that out, but it works.
I am actually doing some update and insert this way. See if I can figure it
out or I'll be back.
Thanks


"Dirk Goldgar" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> In news:e%(E-Mail Removed),
> Phil Hunt <phung1010(remove this)@hotmail.com> wrote:
>> I spoke too soon. The query created by the wizard does not work. It
>> still block me.
>> Need help.
>
> You should be able to use either of these syntaxes:
>
> DELETE FROM [myTable] IN "" "MS
> Access;Database=C:\Protected.MDB;pwd=xxxx";
>
> DELETE FROM [MS Access;Database=C:\Protected.MDB;pwd=xxxx].[myTable];
>
>
> --
> Dirk Goldgar, MS Access MVP
> www.datagnostics.com
>
> (please reply to the newsgroup)
>
>

Please fix your date/time. This post shows to be posted five hours from
now, but it was actually posted yesterday.

Thanks!


..

"Phil Hunt" <phung1010(remove this)@hotmail.com> wrote in message
news:(E-Mail Removed)...
> Hi,
> I am running a query from a MDB to delete records from a table on another
> location.
> The other table is password protected so it kicks out. Is there a way to
> specify the password in this systax ?
>
> DELETE FROM [myTable] In 'C:\Protected.MDB'
>

Hi,
I am running a query from a MDB to delete records from a table on another
location.
The other table is password protected so it kicks out. Is there a way to
specify the password in this systax ?

DELETE FROM [myTable] In 'C:\Protected.MDB'