Comments on AccessBlog.net: How to get rid of ADMIN - 00 tables in database

You are right, it was running a query on a linked ...

2009-10-28T14:12:40.550+03:00

You are right, it was running a query on a linked SQL table using DAO. I converted the code to use ADODB to fix it. I also seem to be getting the problem on pass-through queries accessing a column containing more than 255 characters of text.

Hi, perhaps queries on linked tables also produce ...

2009-10-28T07:56:23.935+03:00

Hi,
perhaps queries on linked tables also produce these errors, but also you could have a linked view with aggregate, or table with computed column. You can try to delete tables from your forms on backup mdb to find out which once produces the error. Would be great if you post result of your findings here

Hi Alex, Many thanks for this info. I have just h...

2009-10-27T19:34:40.425+03:00

Hi Alex,

Many thanks for this info. I have just hit this problem, but using a complex forms bound to a SQL tables. The message I get is "01004 - 0 - [Microsoft][ODBC SQL Server Driver]String data, right truncation". I am pretty sure that the code is not running a pass through query anywhere, but I'll keep looking. Any further info would be fantastic! Thanks.