
October 5th, 2004, 02:04 AM
|
|
Registered User
|
|
Join Date: Oct 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
Update data from MDB to another with password in both MDB's
I've 2 MDB(Access Database) with password set in it.
Tmp.MDB
Temp.MDB
I want to update data in Tmp.MDB to Temp.MDB thru VB 6.0
I wrote
Cnn.Execute "INSERT INTO Contract (Conno, Ccode ) IN 'D:\\Temp.mdb'
SELECT Conno, Ccode FROM Contract"
When no password is set the update is complete.But when a password is set
it gives a message "Invalid Password"
Nirene
|