Invalid database object reference.

[jgelpi16]

I have a function that executes three queries. When I try to execute the queries I receive:

"Run-time error '3276': Invalid database object reference."



Below is my code. I have checked my tables, they are all fine. I haven't run into this error before and don't really know where to start. Thanks in advance.

    Dim vQueryName As String
    
    DoCmd.SetWarnings False
    vQueryName = "qryAppend_HIST"
    DoCmd.OpenQuery vQueryName, acViewNormal

[RuralGuy]

Are you sure you have the name of the query right?

[jgelpi16]

Yes, I had the name of the query right. I ran a compact & repair and it works now...Still not sure what caused the error which concerns me.

[RuralGuy]

The beginnings of corruption. I would *import* everything into a fresh new db and see if the problem follows. http://www.btabdevelopment.com/ts/impnew

[jgelpi16]

Ok, will do. Thanks.