I have been working with Access for 5 years now but I'm just stepping up to the SQL plate so bare with me.

I have a series of update queries that I would like to run routinely against my SQL 2k db. Can I just put them one after another in a stored proc? Or is it one query per proc? If it is how can I call all of them? By writing a single proc to call the others?

What about the programming interface? I mean is there a VBA editor for SQL Server? What if I wrote the queries into a script and had some conditionals in there, would I need to do this in Access and run it againast the SQL tables?

Thanks for any suggestions.

A stored procedure is limited in length to abut 250MB. Stored procedures can contain any number of statements as long as the total length does not exceed this limit.

Find a good text editor to write your code. Or, if you want use Access. Set up a data project to an existing databse and link to your SQL Server database, then you can use Access's designers for creating stored procedures and/or views.

Jeff Mason
Custom Apps, Inc.
www.custom-apps.com

Access is the unfortunate marriage of a front end and a database. SQL Server is just a database server. That means that stuff like VBA, forms, reports etc don't exist. There is the SQL-DMO API and you use SQL. So no VBA API.

regards
David Cameron