Here are a couple links from MSDN that may prove helpful:
I found what looks to be a pretty good article about upsizing to SQL from Access that I think also has some good info:
I've used DAO some in the past, but I only have Access 2000 on my machine at present. One thing to keep in mind is that you can easily set a reference to ADO 2.x in Access 97 and use ADO to execute proc's as well, though you wouldnt be able to bind to the resulting recordset (if there was one). Not a great idea, but an alternative.