Thanks for your help, deceptikon. I have gone through the steps in article 155666 in detail but without success. I will also examine the article you suggest and try everything that it recommends - will let you know next week how I go.
No, I'm not sure my connection string is right. I followed TnTinMN's suggestion (adding 'dns=' to the beginning of the connection string) but it produces an error, "ODBC--connection to 'database.mdb' failed." I then tried eliminating the password from the database and connection string (so that the connection string is "dns=Access"), but this produces the same error. (Note that when the database has no password and the connection string is just the word "Access", it works perfectly.) Next I tried having a look at the ODBC connection for Access 97 and got 2 error messages:
"The setup routines for the Microsoft Access Driver ODBC driver could not be found. Please reinstall the driver."
"Errors found: The specified DSN contains an architecture mismatch between the Driver and Application."
I have the original disk for Access 97 (which I'm using) and have reinstalled that as part of following article 155666, but without fixing the problem.
I'd appreciate any further help you can give. Also note that I currently have another thread going with a page orientation issue in Crystal Reports.