News, links, downloads, tips and tricks on Microsoft Access and related

About Me Search
Name:Alex Dybenko

Location:Moscow, Russia

Monday, August 31, 2009

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

Labels: ,

Wednesday, August 12, 2009

A new method for disabling the Mouse Scroll Wheel in Access forms

Or how to run native code from VBA! I just learned about new method to put native code into memory and run it from Wayne Phillips. Very cool! He made a sample to disable mouse wheel on Access form with that method. Read the tutorial to learn more.

Labels: , ,