Results 1 to 2 of 2

Thread: Database

  1. #1
    Join Date
    Dec 1969

    Default Database

    I was wondering how I can access two tables in a database:<BR><BR>Heres some code:<BR>objConnection.Open "DSN=Prototype"<BR>objRecordset.Open "Books" ??????????<BR>I know how to access one table but how do I access two or more?

  2. #2
    Join Date
    Dec 1969

    Default RE: Database

    Accessing two tables is kind of abiguous<BR>If the two tables are related you have joins of the two tables<BR>in one query<BR>otherwise you can create different recordsets for each table<BR>Note multiple recordsets ONE Connection

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts