You can use data from a table not associated with the current database.
|To access a table associated with or not associated with a database, specify the full path. However, you can increase performance by using only the table name.|
To use data from another database table
Perform one of the following:
Use the USE command with a question mark (?) to display the Use dialog box, and click Other.
Use the USE command and precede the table name with the database name followed immediately by an exclamation point (!).
Tip: The exclamation point is used to refer to a table in a database other than the current database.
Create a view in your database that references the table.
- Use the USE command with a question mark (?) to display the Use dialog box, and click Other.
For example, the following code demonstrates how you can open a table named MyTable in another database called MyDatabase2 and browse the table:
USE MyDatabase2!MyTable BROWSE