Query Insert Into Password Protected Database

Query Insert Into Password Protected Database

Post by Gran » Wed, 02 May 2001 05:14:58

I need to do a query insert into one table that is also password protected.
How do I insert into a database that is password protected? Both tables are
the same but in different database name. Here is what I have so far.

Set db = OpenDatabase(NKWPath, False, False, ";pwd=Xena")

db.Execute "Insert Into [table1] IN """ & pathDB & """ select * From
[table1] "



1. Insert Into Another DB Query does not work for password protected databases

I am trying to insert records from a table in one database into another
database that is PASSWORD but it  gives me the error message "Not a valid
password".  Does anyone know how to get the password clause in this
statement or is this possible.  The exact code works on unprotected

SQL = "INSERT INTO TimeReports ( LName, WorkDay, ) IN 'J:\Auditor.mdb'
SELECT TimeReports.LName, TimeReports.WorkDay, From TimeReports"
db.Execute SQL

Any help would be greatly appreciated.


2. 2nd Call For Papers: GISRUK '93

3. Insert Into access database password protected

4. Update Stored Procedure via Powerbuilder

5. Append query to password protected database

6. NY-Oracle Developer-LOGIC Technology, Inc.

7. Error 29006 - SQL Server Reconciler failed

8. querying ado and two password protected access database

9. password, opening database that is password protected

10. INSERT into password protected table?

11. Query on external -password protected- MDB

12. how do i access a password protected MS-ACCESS db without the password