Results 1 to 6 of 6
  • Thread Tools
  1. Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    What is this table? MSysCeCtblDxCode (Acc2000)

    I noticed by back end database suddenly has some tables that are named as such: MSysCeCtblDxCode. The original table is named: tblDxCode. not all the tables are duplicated this way (about 30 out of 150 tables only).

    What are these? They are empty and I am wondering if I can delete them.

  2. Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: What is this table? MSysCeCtblDxCode (Acc2000)

    Anything named MSsys... is a system file and you shouldn't be *able* to delete it. It's part of Access's internal housekeeping, so don't worry about it.
    Charlotte

  3. Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is this table? MSysCeCtblDxCode (Acc2000)

    Thanks, but why are these all of a sudden showing up in my database window ?- they were never there before.

  4. Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: What is this table? MSysCeCtblDxCode (Acc2000)

    I don't have a clue, but I thought you said these were back end tables, so which database window are you seeing them in?
    Charlotte

  5. Star Lounger
    Join Date
    Sep 2001
    Location
    Pleasanton, California, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is this table? MSysCeCtblDxCode (Acc2000)

    These MSys... tables are showing up in my backend database. They were never there before a few months ago. Again, only some of my original tables have MSys table represetnatives. I can see that Access may have these "in the background" but I am wondering why they are showing up where I can see them. Mainly, they are cluttering up my database window. Could it be I set some obscure setting that makes these show up? And why are not all the tables represented?

  6. 3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: What is this table? MSysCeCtblDxCode (Acc2000)

    Try going to Tools|Options View Tab and uncheck System Objects

Posting Permissions

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