I need to update many tables and columns in an Access '97 database. I prefer to write my SQL statements manually (instead of using the graphical query builder or wizards). I understand how to use Access '97 to manually create a query ("SQL view") and then click the little ! button to get it to run. But what I'd like to do is be able to create many UPDATE statements in one editor window and execute any one of those at a time. This would be akin to using SQL Server Management Studio or Query Analyzer to issue sql batches or *portions* thereof to a SQL Server db. Is there any way to do the equivalent with an MS Access '97 database - or some way to get Query Analyzer or SSMS to connect to an Access '97 database? Any 3rd party tool? Anything? Or am I limited to issuing one query at a time by clicking the ! button. Thanks!