Make-table querie to a protected database

[Paulo Ferreira]

Hello,
I'm trying to run a "make-table" querie that will create a table on
protected database but, every time I try to run the querie, I get a message
saying that the password is wrong.
The command line that in the querie is

G:\PRIMAVERA Software\BaseDados\MET04_LP5_OF2003.mdb ";PWD=PASSWORD"

and the password is correct.
Can someone help me.
Thanks,

Paulo Ferreira

 

[Guest]

Paulo,

the way I like to handle temporary tables is to create them in an external
database, not my front end or backend, but an entirely separate database.
The advantage this has is that it doesn't bloat either the application or
your actual database (because the table is linked). Another advantage is,
that because it is external to your application, you can compact it
programmatically.

Once you have created this temporary database, create the table with the
structure you want it to have and link that table to your application.

Then, rather than writing a make table query, write two queries, one to
delete all the records from this table, and the other to insert into the
table.

HTH
Dale

 

[Gary Walter]

I'm trying to run a "make-table" querie that will create a table on
protected database but, every time I try to run the querie, I get a
message saying that the password is wrong.
The command line that in the querie is

G:\PRIMAVERA Software\BaseDados\MET04_LP5_OF2003.mdb ";PWD=PASSWORD"

and the password is correct.

to make a table "tblA" in remote db...


SELECT
tbl1.*
INTO tblA
IN '' [MS Access;PWD=PASSWORD;DATABASE=G:\PRIMAVERA
Software\BaseDados\MET04_LP5_OF2003.mdb]
FROM tbl1;

(that's 2 single quotes before the bracket)