Using Access 97
I have the need to regularly transfer a table from a local database into another one on the network. Using a macro that runs a series of queries and then the copyobject process, I am able to achieve the copy, having to manually accept the overwriting of the table.
However, for security purposes, the receiving database is now password protected.
I tried using sendkeys with the password and enter, but that doesn't run until after manually entering the password (which is no help then!). I'm looking for a way to automate this to either have the password autofill with the copy OR a way to open the database, do the copyobject and then close. I guess I would want to have this process allow the replace as well.
Thoughts greatly appreciated!
LJ
I have the need to regularly transfer a table from a local database into another one on the network. Using a macro that runs a series of queries and then the copyobject process, I am able to achieve the copy, having to manually accept the overwriting of the table.
However, for security purposes, the receiving database is now password protected.
I tried using sendkeys with the password and enter, but that doesn't run until after manually entering the password (which is no help then!). I'm looking for a way to automate this to either have the password autofill with the copy OR a way to open the database, do the copyobject and then close. I guess I would want to have this process allow the replace as well.
Thoughts greatly appreciated!
LJ