Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Where Did These Tables Come From?

Discussion in 'Information Technology' started by Smartin, Nov 16, 2005.

  1. Smartin

    Smartin
    Expand Collapse
    Guest

    On an A97 DB app I am developing at work, I noticed this morning that
    several new tables were present, and I did not create them. The time
    stamps on the tables seems to coincide exactly with when I closed the
    MDB as I left work on Monday. Some of the tables have data in them
    (nothing resembling what I store in my app tables), although most are
    empty. The MDB is on the network but AFAIK no one else is using it. Any
    ideas where these came from? Here's a sample of the table/field names:

    Table: pbcatcol
    Field: pbc_tnam
    Field: pbc_tid
    Field: pbc_ownr
    Field: pbc_cnam
    [15 more fields like this]
    Table: pbcatedt
    Field: pbe_name
    Field: pbe_edit
    Field: pbe_type
    Field: pbe_cntr
    Field: pbe_seqn
    Field: pbe_flag
    Field: pbe_work
    Table: pbcatfmt
    Field: pbf_name
    Field: pbf_frmt
    Field: pbf_type
    Field: pbf_cntr
    Table: pbcattbl
    [this table has odd looking data in it]
    Field: pbt_tnam
    Field: pbt_tid
    Field: pbt_ownr
    [20 more fields like this]
    Table: pbcatvld
    Field: pbv_name
    Field: pbv_vald
    Field: pbv_type
    Field: pbv_cntr
    Field: pbv_msg
    --
    Smartin
     
  2. Loading...


  3. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    Access uses a number of system Tables whose names start with "MSys". These
    Tables are usually hidden.

    However, the Tables you posted are nothing like the system Tables.

    Are these local or linked Tables?

    --
    HTH
    Van T. Dinh
    MVP (Access)




    "Smartin" <smartin108@yahoo.com> wrote in message
    news:BuidnTCv3q3T9OfenZ2dnUVZ_s6dnZ2d@giganews.com...
    > On an A97 DB app I am developing at work, I noticed this morning that
    > several new tables were present, and I did not create them. The time
    > stamps on the tables seems to coincide exactly with when I closed the MDB
    > as I left work on Monday. Some of the tables have data in them (nothing
    > resembling what I store in my app tables), although most are empty. The
    > MDB is on the network but AFAIK no one else is using it. Any ideas where
    > these came from? Here's a sample of the table/field names:
    >
    > Table: pbcatcol
    > Field: pbc_tnam
    > Field: pbc_tid
    > Field: pbc_ownr
    > Field: pbc_cnam
    > [15 more fields like this]
    > Table: pbcatedt
    > Field: pbe_name
    > Field: pbe_edit
    > Field: pbe_type
    > Field: pbe_cntr
    > Field: pbe_seqn
    > Field: pbe_flag
    > Field: pbe_work
    > Table: pbcatfmt
    > Field: pbf_name
    > Field: pbf_frmt
    > Field: pbf_type
    > Field: pbf_cntr
    > Table: pbcattbl
    > [this table has odd looking data in it]
    > Field: pbt_tnam
    > Field: pbt_tid
    > Field: pbt_ownr
    > [20 more fields like this]
    > Table: pbcatvld
    > Field: pbv_name
    > Field: pbv_vald
    > Field: pbv_type
    > Field: pbv_cntr
    > Field: pbv_msg
    > --
    > Smartin
     
  4. Smartin

    Smartin
    Expand Collapse
    Guest

    Van T. Dinh wrote:
    > Access uses a number of system Tables whose names start with "MSys". These
    > Tables are usually hidden.
    >
    > However, the Tables you posted are nothing like the system Tables.
    >
    > Are these local or linked Tables?
    >


    All are local tables. For additional interest, here is the data I found
    in one field of the "pbcatfmt" table. Looks like something from Excel???

    pbf_name
    #,##0
    #,##0.00
    $#,##0.00;($#,##0.00)
    $#,##0.00;[RED]($#,##0.00)
    $#,##0;($#,##0)
    $#,##0;[RED]($#,##0)
    [General]
    0
    0%
    0.00
    0.00%
    0.00E+00
    d-mmm
    d-mmm-yy
    h:mm AM/PM
    h:mm:ss
    h:mm:ss AM/PM
    m/d/yy
    m/d/yy h:mm
    mmm-yy


    Thanks for your input!
    --
    Smartin
     
  5. david epsom dot com dot au

    david epsom dot com dot au
    Expand Collapse
    Guest

    PBC = Power Builder Catalog

    Sybase, Power Builder, Infomaker

    (david)

    "Smartin" <smartin108@yahoo.com> wrote in message
    news:BuidnTCv3q3T9OfenZ2dnUVZ_s6dnZ2d@giganews.com...
    > On an A97 DB app I am developing at work, I noticed this morning that
    > several new tables were present, and I did not create them. The time
    > stamps on the tables seems to coincide exactly with when I closed the MDB
    > as I left work on Monday. Some of the tables have data in them (nothing
    > resembling what I store in my app tables), although most are empty. The
    > MDB is on the network but AFAIK no one else is using it. Any ideas where
    > these came from? Here's a sample of the table/field names:
    >
    > Table: pbcatcol
    > Field: pbc_tnam
    > Field: pbc_tid
    > Field: pbc_ownr
    > Field: pbc_cnam
    > [15 more fields like this]
    > Table: pbcatedt
    > Field: pbe_name
    > Field: pbe_edit
    > Field: pbe_type
    > Field: pbe_cntr
    > Field: pbe_seqn
    > Field: pbe_flag
    > Field: pbe_work
    > Table: pbcatfmt
    > Field: pbf_name
    > Field: pbf_frmt
    > Field: pbf_type
    > Field: pbf_cntr
    > Table: pbcattbl
    > [this table has odd looking data in it]
    > Field: pbt_tnam
    > Field: pbt_tid
    > Field: pbt_ownr
    > [20 more fields like this]
    > Table: pbcatvld
    > Field: pbv_name
    > Field: pbv_vald
    > Field: pbv_type
    > Field: pbv_cntr
    > Field: pbv_msg
    > --
    > Smartin
     
  6. Van T. Dinh

    Van T. Dinh
    Expand Collapse
    Guest

    It looks like some sort of formatting codes.

    Since I have never seen these Tables, I would suggest try some of the
    following (Make a back-up copy FIRST):

    * Compact & repair your database.
    * Delete these Tables & then compact & reapir your database.
    * If necessary, create a new database and import all objects from the
    existing database except these Tables.


    --
    HTH
    Van T. Dinh
    MVP (Access)



    "Smartin" <smartin108@yahoo.com> wrote in message
    news:1KqdnTeWybSi8ufenZ2dnUVZ_t-dnZ2d@giganews.com...
    > Van T. Dinh wrote:
    >> Access uses a number of system Tables whose names start with "MSys".
    >> These Tables are usually hidden.
    >>
    >> However, the Tables you posted are nothing like the system Tables.
    >>
    >> Are these local or linked Tables?
    >>

    >
    > All are local tables. For additional interest, here is the data I found in
    > one field of the "pbcatfmt" table. Looks like something from Excel???
    >
    > pbf_name
    > #,##0
    > #,##0.00
    > $#,##0.00;($#,##0.00)
    > $#,##0.00;[RED]($#,##0.00)
    > $#,##0;($#,##0)
    > $#,##0;[RED]($#,##0)
    > [General]
    > 0
    > 0%
    > 0.00
    > 0.00%
    > 0.00E+00
    > d-mmm
    > d-mmm-yy
    > h:mm AM/PM
    > h:mm:ss
    > h:mm:ss AM/PM
    > m/d/yy
    > m/d/yy h:mm
    > mmm-yy
    >
    >
    > Thanks for your input!
    > --
    > Smartin
     
  7. Jerry Porter

    Jerry Porter
    Expand Collapse
    Guest

    Smartin,

    Here are some things you might try:

    - Delete (or rename) the tables. Do they get recreated when you close
    the database?
    (you might want to work in a copy of the database)
    - Search the code modules for any references to these tables.
    - Did you run a Repair? That would have changed the time stamps for
    existing tables.
    - Can your verify that no one else is using the database?
    - Could there be some external automated process that copies these
    tables into the db?

    Jerry

    The data you listed in your other message is a list of formats that are
    valid in Access as well as Excel.
     
  8. Smartin

    Smartin
    Expand Collapse
    Guest

    david epsom dot com dot au wrote:
    > PBC = Power Builder Catalog
    >
    > Sybase, Power Builder, Infomaker
    >
    > (david)
    >


    Aha! I was attempting to use Infomaker earlier in the day to tap in to
    my MDB.

    Is this possibly the smoking gun, and what business does Infomaker (or
    any of the others) have creating tables in my project?

    Interesting!
    --
    Smartin
     

Share This Page