Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

repair invalid links ~tmpclp

Posted on 2006-11-02
3
Medium Priority
?
353 Views
Last Modified: 2008-02-20

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
Comment
Question by:vbstroehle
  • 2
3 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 total points
ID: 17863096
create a blank db and import all objects to the new db.
0
 

Author Comment

by:vbstroehle
ID: 17863949

ended up doing that, thought there may have been another option.
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 17863963
when you mentioned about the permissions, the first thing that came to my mind is the one i suggested.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…
Suggested Courses

571 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question