spacerules said:
How do you get all of the tables of a different database into
yours and have it upgrade with the older one?
If you mean, as I read this, that you want actual copies of the tables in
two different databases and have updates synchronized (when one is updated,
so is the other), you cannot, because Access has no capability to
automatically update or synchronize tables in two databases. If all you
want is a one-time import of the data, and then you are going to discard or
not update the original database, then Steve/Mark has given you that...
File | Get External Data | Import.
If you simply mean you want access from your database to the most current
data in another, that is relatively simple, provided your database user has
necessary permissions on the disk/folder where the database with the data
resides. On Access 2003 and earlier, on the menu File | Get External Data |
Link Tables and follow the prompts to link to the Tables in the other
database.
There are several other approaches that could work, as well -- split the
tables from the "front end" (user interface) and link both of the front ends
to the Tables (this is a recommended approach for a number of reasons... see
MVP Tony Toews' site,
http://www.granite.ab.ca/accsmstr.htm, for discussions
of split databases, performance, and avoiding corruption). Or, you could
migrate the Tables into a Server Database (MS SQL Server, or other
ODBC-compliant database) and link them from both front-ends.
I need to go from a different folder.
I don't understand the pertinence of this requirement... that is no trouble
at all if both users have access to and permissions on the folders...
create, read, write, and delete.
Larry Linson
Microsoft Office Access MVP
