Hello I have installed the MySQL server on a Windows 2000 server, and set up passwords and usernames. And one database with 3 tables. Each tables uses auto increment fields. (these are marked as index fields as they should be). And then i have inserted a few test records. When i do a standard query useing mysql promt, it looks fine.("SELECT * FROM tbl;") But when i do it in ASP useing a DSNless connection in ADODB it dosnt work. When i specify which fields it should return, it does the same. But when i remove the autoincrement id field, it works fine. ("SELECT name, desc FROM tbl;") What could be wrong? Venlig Hilsen / Best regards Christian Rytter AC Software [EMAIL PROTECTED] http://www.ac-ware.com