by Gran » Wed, 02 May 2001 05:14:58
Set db = OpenDatabase(NKWPath, False, False, ";pwd=Xena")
db.Execute "Insert Into [table1] IN """ & pathDB & """ select * From
[table1] "
db.close
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
databases.
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.
Greg
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