query to append data to tables in another database that is password protected

[June Macleod]

Can anyone tell me how I could append records from a table in one database
to a table in another database when the second database is password
protected?

I have set up an append query and set the DestinationDB to the second
database. The query works but it asks me for the password each time. Is
there anyway to pass this information across with the query?

Thanks in advance

June Macleod

 

[BayesTex]

Hi June,

I am a Access newbie, and I have the same question you posted her
about append records between tables of two databases.

So I would like to know if you fix it already, to ask you how did yo
do.
I would be good if you could write in a step-by-step way.

Thanks in advance,

Jaime L.

*Can anyone tell me how I could append records from a table in on
database
to a table in another database when the second database is password
protected?

I have set up an append query and set the DestinationDB to th
second
database. The query works but it asks me for the password each time
Is
there anyway to pass this information across with the query?

Thanks in advance

June Macleod

-
BayesTe

 

[Gary Walter]

Hi BT,

If local table is "tbl1"
and you wanted to append
all records from local table "tbl1"
into "tblA" of a remote Access db whose
path was "C:\My Documents\test.mdb"
and whose password was "fred",

insert into pwd protected db:

SELECT tbl1.* INTO tblA
IN '' [MS Access;PWD=fred;DATABASE=C:\My Documents\test.mdb]
FROM tbl1;

(that is 2 single quotes, not a double quote,
after the IN)

This is a simple append example where
both tables share the same number and
type of fields, but illustrates how to reference
the remote, password-protected db.

For help with your specific append,
try linking to the remote db
(File/Get External Data/Link Tables...),
construct your append query using
the linked remote table, then in SQL View,
copy and paste the SQL back here in
a further post. Also, please include full
path to the remote db.

Good luck,

Gary Walter