Import from one DB to another
I know it is nearly a year since I last posted, but I have had time off for a heart operation and have only just got back to this....
I have script that rebuilds the database when Table Definitions change. It imports all records from a source database to an updated one. Following advice in her last year (I know, but I have been off sick)
How do I remove password protection from the source file?
I can create an account that has no password, but I am still prompted for user name and password on every Import step in the script. Having no password speeds up the operation (press Enter each time, rather enter a password and press Enter) but it would be better if I was not prompted at all.