Tables appearing Admin - 01, Admin - 02 but no LogMessages

[jsteph]

Hi all,
I'm getting the "Admin - 00", "Admin - 01", etc. tables appearing in my .mdb (Access 2003 on Win 7 64-bit), and it's coming from a Pass-thru query with the "Log Messages" most definitely set to "NO".

It's definitely any PT query with a "USE" statement. I can sit there and run it and watch the tables appear instantly as I run it.

The "message" isn't an error, it's just the message that I'm changing db context which the Use stmt does.

The only thing 'different' is that I'm now running this .mdb (which has never done this before) on Win 7 64-bit. I'm just wondering if anyone's seen this behavior before, and might know a workaround on how to stop it.

It is fully reproducable (for my system, anyway) on any Access 2003 db with a passthru that uses the "USE dbname;" in the query, with LogMessages = NO.
Thanks for any help,
--Jim

 

[MazeWorX]

If the tables are of no use to you then you could loop through the tables collection and delete them.

        For Each tbl In CurrentData.AllTables
            If tbl.Name Like "Admin *" Then
                DoCmd.DeleteObject acTable, tbl.Name
            End If
        Next tbl

HTH << MaZeWorX >> "I have not failed I have only found ten thousand ways that don't work

 

[jsteph]

Yes, but deleting them isn't the problem, they keep coming back. It really appears to be an Access2k3 on Win7 issue, it doesn't happen elsewhere. And most of this project is passthru queries and since it hits multiple db's the USE statement is in most of them.

I think it's just one of those bizarre bugs, and since 2003 is such an old version I'll have to live with it.
--Jim