Where Did These Tables Come From?

[Smartin]

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

 

[Van T. Dinh]

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?

 

[Smartin]

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!

 

[david epsom dot com dot au]

PBC = Power Builder Catalog

Sybase, Power Builder, Infomaker

(david)

 

[Van T. Dinh]

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)

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!

 

[Jerry Porter]

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.

 

[Smartin]

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!