I'm unfamiliar with Microsoft Access 2003, but have a client who uses it and uses ODBC access, but his website was moved to a new server, therefore changing the hostname. Can someone tell me where to find the DSN settings to change the hostname?
If you design the links to the database tables (skip the warning) and then look at the properties, you should be able to see the connection string for the table. In the connection string it should tell you the name of the DSN. Or if it doesn't designate the DSN variable then it is a DSNless connection. In which case it would probably be a function in the database that is doing the connecting.