Results 1 to 5 of 5
  1. #1
    mrkaye is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2010
    Posts
    43

    Blank Table

    This sounds crazy, i had to re-install access 2010 64 bits, because every time i open my table there are other tables in the list of tables it wont let me delete them, it says i don't have permission to do so. the files are named "MSysACEs, MSysComplexColumns, MSysNavePaneGroupCategories. and more tables starting with MSys.
    i have removed my database from the computer and started fresh with access 2010 in a different drive and tried opening a blank table but when i did the other tables showed up, and i don't know where they came from or how to get rid of them...

    PLEASE HELP
    Martin

  2. #2
    trevor40's Avatar
    trevor40 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    407
    Hi, that is normal, they are system tables. If you don't want to see them, then under Tools..Options..View Deselect system objects. If this is allready unticked then you have a problem. These files will be in all access db's. the setting above will show/not show them.

    1000 ways to skin a cat, allways looking for another one...
    Use MDB format for sample post. If your issue is fixed, mark the thread solved.
    Click on the star below if this has helped.

  3. #3
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    If you could get rid of them, Access would not work. They are named *Sys* for a reason, they are system tables and essential for Access to function. As trevor says, you can hide them. This is an application setting, not a database setting, and will apply regardless of the database being worked with.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  4. #4
    mrkaye is offline Advanced Beginner
    Windows 8 Access 2010 32bit
    Join Date
    Nov 2010
    Posts
    43
    i think i understand what you are saying, now i am running access 2010 64 bit under windows 8.1. how and where do i change the settings that you describe.

  5. #5
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,622
    Right click on the top bar of the navigation pane > Navigation Options > make settings as desired.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 03-11-2014, 11:30 AM
  2. Blank Record Being Added to Table
    By Andrew in forum Programming
    Replies: 8
    Last Post: 12-22-2011, 04:41 AM
  3. Blank Records in Table
    By anwaar in forum Access
    Replies: 3
    Last Post: 09-02-2011, 02:18 PM
  4. Replies: 4
    Last Post: 05-11-2011, 03:06 AM
  5. ODBC table read to blank Access table write
    By dibblejon in forum Access
    Replies: 2
    Last Post: 03-10-2010, 08:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums