I'm told it would take too much work to rebuild this dbBy "rebuild", we don't mean "recreate". We mean to create a new, blank database and use the Access Import feature to move everything from the old db to the new. Shouldn't take more than about 5 minutes, assuming you grab a cup of coffee during the process :)
Check out this site for instructions.
I'm on my iPad or I would copy the procedure I use. I have a subroutine which I simply pass a database name and a schema name (optional) which builds the connection string, creates a local table with a name that drops the normal "dbo_" prefix that you get when you link to a SQL Server table, sets the tdf.Connect property and the tdf.SourceTableName property and creates the link.
This is a little more taxing than using the External Data - ODBC dialog, but is easy for me.