I've been trying to copy the tables collection into a new database.  
Whenever I enumerate all of the tables however, these tables appear as 
part of the alltables collection.

MSysAccessObjects
MSysACEs
MSysObjects
MSysQueries
MSysRelationships

I was just wondering what exactly they are and how to either copy them or 
bypass them.  Thanks for any help!

If you are using ADO and an ADOX catalog these tables will have a .Type of
either ACCESS TABLE or SYSTEM TABLE.  Their names also all start with MSys.
They are system tables that Access uses to store data about the MDB.

|-----Original Message-----
|From: Brent Mills [mailto:bmills@a...]
|Sent: Tuesday, July 16, 2002 7:58 PM
|To: Access
|Subject: [access] weird table names
|
|
|I've been trying to copy the tables collection into a new database.
|Whenever I enumerate all of the tables however, these tables appear as
|part of the alltables collection.
|
|MSysAccessObjects
|MSysACEs
|MSysObjects
|MSysQueries
|MSysRelationships
|
|I was just wondering what exactly they are and how to either copy them or
|bypass them.  Thanks for any help!
|

The tables prefixed 'MSys' are system tables - you do not need to copy them
into the new database because the new database has it own set of system
tables - these will be updated as you copy the tables into the new
database. Add some code to exclude these tables, e.g.

    If Left$(strName, 4) <> "MSys" Then
        ' do whatever you need to do if table names do not begin with MSys
    End If

The system tables can be seen if you select 'system objects' in
Tools/Options/View but otherwise are hidden.



<<I've been trying to copy the tables collection into a new database.
Whenever I enumerate all of the tables however, these tables appear as
part of the alltables collection.

MSysAccessObjects
MSysACEs
MSysObjects
MSysQueries
MSysRelationships

I was just wondering what exactly they are and how to either copy them or
bypass them.  Thanks for any help!>>

*************************************************************************

This e-mail may contain confidential information or be privileged. It is intended to be read and used only by the named
recipient(s). If you are not the intended recipient(s) please notify us immediately so that we can make arrangements for its return:
you should not disclose the contents of this e-mail to any other person, or take any copies. Unless stated otherwise by an
authorised individual, nothing contained in this e-mail is intended to create binding legal obligations between us and opinions
expressed are those of the individual author.

The CIS marketing group, which is regulated for Investment Business by the Financial Services Authority, includes:
Co-operative Insurance Society Limited Registered in England number 3615R - for life assurance and pensions
CIS Unit Managers Limited Registered in England and Wales number 2369965  - for unit trusts and PEPs
CIS Policyholder Services Limited Registered in England and Wales number 3390839 - for ISAs and investment products bearing the CIS
name
Registered offices: Miller Street, Manchester M60 0AL   Telephone  0161-832-8686   Internet  http://www.cis.co.uk   E-mail
cis@c...

CIS Deposit and Instant Access Savings Accounts are held with The Co-operative Bank p.l.c., registered in England and Wales number
990937, P.O. Box 101, 1 Balloon Street, Manchester M60 4EP, and administered by CIS Policyholder Services Limited as agent of the
Bank.

CIS is a member of the General Insurance Standards Council

CIS & the CIS logo (R) Co-operative Insurance Society Limited

********************************************************************************