Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003
    Posts
    3

    Unanswered: System Objects in MS Access'97

    Hi,

    I am currently using Ms Access'97. I have tables which have some system object (column's). Is there a way, programmatically [ADO or otherwise], through which I can find which columns are system objects.

    Any/All help welcome.

    Thanks,
    Gaurav Gupta

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    I often go through the TableDefs collection looking for my tables and skipping the system tables and only using the False part of the if statement:

    For Each Tbf In db.TableDefs
    If (Tbf.Attributes And dbSystemObject) Then
    Else
    ... my code goes here ...
    end if
    next
    If you want the system tables only, you would want put your code into the True section.

Posting Permissions

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