AnsweredAssumed Answered

Import from one DB to another

Question asked by on Jun 1, 2015
Latest reply on Jun 1, 2015 by


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.