database engine could not find the object

[MadTom]

I get this error when I try to copy a table?


The Microsoft Access database engine could not find the object <table name>. Make sure the object exists and that you spell its name and the path name correctly. If '<table name>' is not a local object, check your network connection or contact the server administrator

Maybe a setting? everything is closed but DB. Not on a server, accdb file. Access 365
Thanks!

[isladogs]

Sounds like you have just typed the name incorrectly ...or it has a space or special character in the table name.
If it has a space or special character, enclose it in [].

If none of that is true, please post the code you used

[MadTom]

What I'm doing is copying a table, I go to paste table, it has copyofxxxtable. I click ok and then I get the error. Not in VBA. Just in Nav pane.

[isladogs]

In that case, either you have errors in the MSysObjects system table or you need to run an Office repair.

[JoeM]

If you have some sort of corruption, one way to fix it is to create a brand new, blank database.
Then import all of your objects from the old database into the new one.
This will ensure that the new copy has all the required system tables without any errors/corruption.

[MadTom]

Thanks JoeM, I had to do what you suggested. I've been working with this problem for awhile, many backups with the same problem, didn't find it till I wanted to copy or rename a table in Nav Pane.
Thanks for your help!

[JoeM]

You are welcome.

[MadTom]

I have a new DB copy from the old one. I find I get the same problem when I run this code. This form is a utility only used to change table to a backup or startup table.
I don't get any errors when this form runs and all seems to work, just the corruption in Sys files.
Thanks, Mad-Tom

DoCmd.CopyObject , PartsName_global & Now(), acTable, PartsName_global  'make a backup of PartsName_global    
    DoCmd.CopyObject , "tblPartsBackup" & Now(), acTable, "tblParts"  'make a backup of tblParts to tblPartsBackup
    DoCmd.DeleteObject acTable, "tblParts"
    DoCmd.Rename "tblParts", acTable, PartsName_global

[isladogs]

You can't rename tblParts as you had just deleted it with the previous line of code.
So Access correctly states it cannot find the object tblParts...as it no longer exists

[MadTom]

Did I have this wrong?
The Newname table was deleted first then a rename PartsName_global[ to tlbParts.
DoCmd.Rename "Newname", acTable, "OLDNAME*"

DoCmd.Rename "tblParts", acTable, PartsName_global

Thanks!

[JoeM]

Look at these two lines of code that you have:

    DoCmd.DeleteObject acTable, "tblParts"
    DoCmd.Rename "tblParts", acTable, PartsName_global

The first line is deleting the table named "tblParts".
The second line is then trying to rename the table named "tblParts".
But you cannot do that, as you just deleted it in the previous line! It no longer exists!

[MadTom]

Ok I see I don't need to delete table, Rename is all I need. I'm still working on errors on new DB.
I get Error 3270 when I use this code. Didn't have this with old DB with same forms.
Could this be connected to Reference Library setting?

Thanks!

CurrentDb.Properties("AllowFullMenus") = False        CurrentDb.Properties("AllowShortcutMenus") = False
        CurrentDb.Properties("AllowBuiltinToolbars") = False

[Micron]

Some db properties cannot be set until they are added/created in a particular db. I'm not sure if those are in that group. You probably have code in the other db that creates them first but you didn't do that in the new one. If your error message doesn't apply, ignore my post. It's just that you didn't state what the error text is and there are thousands of error numbers and I doubt anyone knows them all. It would be appreciated if you provided the info because I'm too lazy to look it up for everyone every time.

[isladogs]

Error 3270 is indeed Property not found as Micron rightly surmised.
I only know that from working with code to add new properties. But you really need to provide that information yourself.

Anyway, those are three standard properties that can easily be set from Access options.
Suggest you do so, then run the code again. If you still get the error, you have mis-spelled one of them.

[MadTom]

How do I add Property that I need? I do not see them in Access options, maybe missed them?
I did new DB and they are not there?
I used this code to list them.

Public Sub ListDBProps()    Dim db As Database
    Dim prp As Property


    Set db = CurrentDb


    For Each prp In db.Properties
        MsgBox prp.Name

    Next prp