Importing a Table from Database to Database

[jbruno]

I would like to create a macro to import a table from database1 to database2. I would like this to occur each time someone opens database2. I created a transferdatabase macro in database2, however I get the error message "The database engine can't find <name>. Make sure it is a valid parameter or alias name, that it doesn't include invalid characters or punctuation, and that the name isn't too long. (Error 3125". I belive the path is greater than 64 characters, is this the problem?. Also, database1 is password protected. Is there a way to do this w/o someone needing to input the passord each time? I do not want to link the databases because I do not what people to be able to change data in database1. Thank you in advance for your help.