>Is there a utility that will export a SQL Server database to access. Ideally it would create the structure too, but if I have to manually create the Access database once, that would be fine.

I haven't done it, but it looks like you can use DTS to do this. Also, I'd bet the red-gate sql tools does it (www.red-gate.com).