none
Table already exists but it not in access database

    Question

  • Hi,

    I have a table Master_A.

    When i open database it not there.

    when i create it i receive a message table already exists.

    but there is not table.

    Art Of Living Is Art Of Giving

    Friday, April 12, 2013 12:36 PM

Answers

  • Check the navigation options, whether hidden objects are displayed or not.
    Friday, April 12, 2013 12:47 PM
  • I suspect that this database is corrupt. User "Engine" should not be the owner of the objects. I think you should use some tools to recover data/objects from the file

    Michał

    Thursday, April 18, 2013 6:22 AM

All replies

  • Check the navigation options, whether hidden objects are displayed or not.
    Friday, April 12, 2013 12:47 PM
  • As Stefan pointed out, check for hidden objects.

    An easy way to check whether the table exists no matter if it's visible: go to Immediate window (CtrlG), write down

    ?CurrentDb.TableDefs("Master_A").Name

    and press Enter.

    You will receive an error message (error 3265) it the table doesn't exist. Otherwise the result will be Master_A.


    Vladimir Cvajniga



    Friday, April 12, 2013 1:39 PM
  • In your navigation pane make sure you have selected view all objects or at least view tables.


    Chris Ward

    Friday, April 12, 2013 7:16 PM
  • Thanks for reply

    I checked it on navigation option and when i checked on 'Show System Objects' then it show the table in gray color.

    but how a normal table convert into system object and how i recover it. 


    Art Of Living Is Art Of Giving

    Saturday, April 13, 2013 7:54 AM
  • In VBA:

    Sub setAsSystem(ByVal tbName As String, Optional asSystem As Boolean = True)
        If Not IsNull(DLookup("Name", "MSysObjects", "Name='" & tbName & "' And Type=1")) Then
            CurrentDb.TableDefs(tbName).Attributes = IIf(asSystem,  dbSystemObject, 0)
        End If
    End Sub

    Set as system table:

    setAsSystem "Master_A"

    set as non-system:

    setAsSystem "Master_A", False


    Michał

    Saturday, April 13, 2013 12:17 PM
  • 

    Hi Dziubek Micha 

    Thanks For reply 

    I Got This error

    I am not familiar with VBA ,but i try and got error

    SetupSuperman is another table like Master_A. Both Table giving error.

     


    Art Of Living Is Art Of Giving

    Wednesday, April 17, 2013 6:03 AM
  • Can you publish this file? Only with this table...

    And check permissions: tools/security/user and group permissions


    Michał

    Wednesday, April 17, 2013 7:36 AM
  • Hi Dziubek Micha  

    i Link access file.please download it.

    Access file


    Art Of Living Is Art Of Giving

    Wednesday, April 17, 2013 1:12 PM
  • I think this is not system table, have you mdw (worgroup file) for this db?

    Michał

    Wednesday, April 17, 2013 2:06 PM
  • No i have only MDB file.

    Art Of Living Is Art Of Giving

    Thursday, April 18, 2013 6:12 AM
  • I suspect that this database is corrupt. User "Engine" should not be the owner of the objects. I think you should use some tools to recover data/objects from the file

    Michał

    Thursday, April 18, 2013 6:22 AM
  • OK Fine Thanks for Help


    Art Of Living Is Art Of Giving

    Thursday, April 18, 2013 8:41 AM