O'Reilly logo

Special Edition Using Access 97, Second Edition by Roger Jennings

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Adding IN to Use Tables in Another Database

Access enables you to open only one database at a time, unless you write code to open another table with an Access VBA function or subprocedure. However, you can use Jet SQL's IN clause with a make-table, append, update, or delete query to create or modify tables in another database. Access provides the capability to make a table or append records to a table in another Access database through graphical QBE only. You click the Another Database option in the Query Properties dialog for the make-table or append query and type the file name of the other database.

You have to write a SQL query or edit a query created by Access to update data or delete records in tables contained in another database of any ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required