Query "INSER INTO" with password on databases (Access)

From: ntex (m)
Date: 01/21/05 

Date: Fri, 21 Jan 2005 20:06:41 -0000

I have nasty problem I need to use a query to insert records from a table to
another table (access) but, both tables have passwords, I'm using VB6
through ADO, but I can't make it, always have an error, if I put the
password gives an error on syntax "insert into", if I don't of course gives
an error that is invalid password.
Example of SQL used:

INSERT INTO [;PWD=password].TableZ ( Field1, Field2 ) IN
'D:\Incoming\z.mdb'[;PWD=password]
SELECT Field1, Field2 FROM TableX;

Can anyone give me a hand. Thanks.

Relevant Pages

  • Query "INSER INTO" with password on databases (Access)
    ... I have nasty problem I need to use a query to insert records from a table to ... SELECT Field1, Field2 FROM TableX; ...
    (microsoft.public.vb.database)
  • Re: Combo-Box list unsorting
    ... RecordSource property and select it. ... it'll take you to the query. ... drag-dropping fields from Table1 to the Form. ... want one of the fields (say Field2) in Table1 and the Form. ...
    (microsoft.public.access.gettingstarted)
  • Re: Combo-Box list unsorting
    ... I am still in the process of creating my database. ... However, in the form Field option, I still see Field2 (ex. ... query as the RowSource for the combo box rather than just the table. ... Source a field I (called visitType) in a table called visits. ...
    (microsoft.public.access.gettingstarted)
  • Re: need to delete record having two different fields with same identical value
    ... Assuming you're always comparing the same two fields (Field1 and Field2) ... Run the query to check it, and then turn it into a delete query. ... which might be a lot safer (I hate deleting data unless I ...
    (microsoft.public.access.gettingstarted)
  • Re: Using flexible query criteria
    ... criteria for the query is based on the user's input in the main form. ... One of the user inputs is a field called "Vendor_Name" (in the form of ... and said that Field1 is the primary key and is an autonumber field, and Field2 is the field shown in the combo box, you must modify it to a UNION select, similar to ...
    (comp.databases.ms-access)