>>Plus, it prompts for the location of the mdb file every time I open the view and refuses to save the information. This is not usable.

When you define the ODBC data source, you can select which mdb to use. there is a command button called, "Select database" or something like that.