I have two access database and both are split for multiple users. I want to be able to import Table 1 from Database 1 into Database 2 using the same table name. I need it to overwrite the table every time Database 2 is opened so that the info is current. I was going to write a macro but it doesn't look like you can still do that in Access 2010. Any suggestions?