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
| 
![[info]](http://l-stat.livejournal.com/img/userinfo.gif){kind=small}
accessblog's journal
