Where Did These Tables Come From?

#1 (**permalink**) 16-Nov-2005, 14:51 PM

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]
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7484-where-did-these-tables-come-from.html
Field: pbt_tnam
Field: pbt_tid
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
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 (**permalink**) 16-Nov-2005, 14:51 PM

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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484

--
HTH
Van T. Dinh
MVP (Access)

"Smartin" 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]
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
> 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

#3 (**permalink**) 16-Nov-2005, 14:51 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
m/d/yy h:mm
mmm-yy

Thanks for your input!
--
Smartin

#4 (**permalink**) 16-Nov-2005, 14:51 PM

PBC = Power Builder Catalog

Sybase, Power Builder, Infomaker

(david)

"Smartin" 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
> 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]
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
> Table: pbcatvld
> Field: pbv_name
> Field: pbv_vald
> Field: pbv_type
> Field: pbv_cntr
> Field: pbv_msg
> --
> Smartin

#5 (**permalink**) 16-Nov-2005, 14:51 PM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
* 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" 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???
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
>
> 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

#6 (**permalink**) 16-Nov-2005, 14:51 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
existing tables.
- Can your verify that no one else is using the database?
- Could there be some external automated process that copies these
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
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.

#7 (**permalink**) 16-Nov-2005, 14:51 PM

david epsom dot com dot au wrote:
> PBC = Power Builder Catalog
>
> Sybase, Power Builder, Infomaker
>
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
> (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!
--
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7484
Smartin