How to get rid of ADMIN - 00 tables in database
If you are running pass-through queries in your database – you can suddenly get a lot of ADMIN – 00, ADMIN – 01, etc. tables. Office Online article Create tables from the results of a pass-through query (MDB) explains why this happens:
Some pass-through queries can return messages in addition to data. If you set the query's LogMessages property to Yes, Access creates a table that contains any returned messages. The table name is the user name concatenated with a hyphen (-) and a sequential number starting at 00. For example, the default user name is ADMIN so the tables returned would be named "ADMIN - 00," "ADMIN - 01," and so on.
Even you set LogMessages property to No – you can get such messages. For example - in one application I am continuously getting message like:
01003 - 8153 - [Microsoft][ODBC SQL Server Driver][SQL Server]Warning: Null value is eliminated by an aggregate or other SET operation.
To get rid of it – you have to find query, which produce this message and fix it. In my case it was a query with SQL:
Select ProductID, Sum(Qty) as Shipped from tblOrder
Qty field had some null values and is was a source of this message. So I fixed it like this:
Select ProductID, Sum(Qty) as Shipped from tblOrder where not Qty is null