• 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 lets you open only one database at a time unless you write code to open another table with a 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 the Query Design window. You click the Another Database option in the Query Properties dialog for the make-table or append query and type the filename of the other database.

You must write an 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 FoxPro, dBASE, or Paradox 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 disadvantage of using the IN clause is that indexes associated with FoxPro, 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