How do I do this ?

[Phil Hunt]

Hi,
I did not mean to re-post, but I gave myself the wrong answer. Here wer go.

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'

 

[Jerry Whittle]

Another option: On the menu go to File, Get External Data, Link Tables. Find
the database and table which you want. You should be prompted for a password.
After that you should be able to delete records from that table with a simple
delete query.

 

[Dirk Goldgar]

In

Hi,
I did not mean to re-post, but I gave myself the wrong answer. Here
wer go.
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'

See my reply in your original thread.