Hi, Here's what I did to make it crash: CRATE VIEW tmpView AS SELECT count(*) FROM myTable; SELECT * FROM tmpView; - crash. Every single time. Anyone knows why and how to make it work? Thanks. Sze Wong _________________________________________________________ DO YOU YAHOO!? Get your free @yahoo.com address at http://mail.yahoo.com