When doing an import, in our case from dBase, is it better to make a new table or link to the table? If you link to the table how does it effect the performance of Access?
Also, I like the idea of viewing all my tables in that left navigation pane. But I'm not sure that I want all of my tables within 1 database. I have multiple tables that, in one way or another, are related to eachother. If I have each table in it's own database can I still view all my tables in that left navigation pane? If a table is in a different database, can I still have a relationship between the two tables?
Thanks,
Heather
Also, I like the idea of viewing all my tables in that left navigation pane. But I'm not sure that I want all of my tables within 1 database. I have multiple tables that, in one way or another, are related to eachother. If I have each table in it's own database can I still view all my tables in that left navigation pane? If a table is in a different database, can I still have a relationship between the two tables?
Thanks,
Heather