Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

repair invalid links ~tmpclp


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.


0
vbstroehle
Asked:
vbstroehle
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
create a blank db and import all objects to the new db.
0
 
vbstroehleAuthor Commented:

ended up doing that, thought there may have been another option.
0
 
Rey Obrero (Capricorn1)Commented:
when you mentioned about the permissions, the first thing that came to my mind is the one i suggested.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now