• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 23. Working with Structured Quer... > Adding IN to Use Tables in Another D...

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 type, or to perform any operation on a dBASE, Paradox, or Btrieve file that isn't attached to your database. The SQL query uses the IN clause to specify the external database or table file. The advantage of using the IN clause is simplicity— you don't have to attach the table before using it. The dis-advantage of using the IN clause is that indexes associated with dBASE and Paradox tables aren't updated when the content of the table is modified.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint