How do I specify the password in this query

[Phil Hunt]

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

thanks

I got it using the wizard.
DELETE FROM [myTable] In 'C:\Protected.MDB' [;PWD=xxxx]

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'

 

[Dirk Goldgar]

In

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];

 

[Phil H]

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

In

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)

 

[RBear3]

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

Thanks!


..

 

[Phil Hunt]

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'