HELP Importing a Table from Database to Database

[jbruno]

I would like to automatically import a table from database1 to database2 whenever someone opens database2. I want people to have the most current information but I do not want the databases linked for security reasons. I had created a macro to import the data, but database1 is password protected and each time the macro would run, the password dialog box would pop up. I would like to automate this. Also, will Access automatically overwrite the table with the imported version or will it want to rename it or something? I'm using Access97. Thank you for your help.

 

[The_Doc_Man]

You could do a lot of things "behind the scenes" in a startup form. On the Form_Load event, you could put whatever code you wanted. Unfortunately, you are not going to eliminate the password protection requirement.