i have an access database that has a number of deleted odbc linked tables listed in MsysObjects.
When i delete these tables from the SQL server i get an error when running the access database. The database refuses to open. It tells me to consult the system administrator, as well as identifying a ~tmpclpXXXXX table as the cause of the problem.
If i put the table back on the SQL server the probem goes away and database behaves normally. (strange as its a deleted link)
to get into the db i have to hold down the shift key, then running a compact repair does not fix the problem.
I tried to delete the rows from the MsysObjects table but couldn't give myself enough permissions to do this.
how can i fix this problem as i need to remove the databases from the server.