>How come when I create a Local view I have to give it the path where the tables are or it won't open?

I think this is because it only stores the Database and table name not the paths to them. I've found that as long as all the databases are open then the views open correctly.