Schema Object

Results 1 to 2 of 2

Thread: Schema Object

  1. #1
    Join Date
    Dec 1969

    Default Schema Object

    Is there a way to use the schema object and only retrieve tables from the database with like a default suffix, or prefix. <BR><BR>tables: <BR> scranks <BR> hwranks <BR> scnews <BR> hwnews <BR> eqranks <BR> eqnews <BR> ..ranks <BR> <BR> etc.. <BR>I only want to retrieve tables that have the ranks suffix, is this possible. If its important i am running access 2000 <BR><BR>Original question at:

  2. #2
    Nils Bilhorn Guest

    Default RE: Schema Object

    Well, you may try this, I&#039;m not sure whether it will work, as I don&#039;t use Access<BR><BR> set rs = conn.openSchema (adSchemaTables,array("%","%","%ranks"))

Posting Permissions

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