Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

can't delete linked table

Status
Not open for further replies.

citychap26

Programmer
Sep 19, 2004
144
GB
Hi Guys

Just found a database with a linked table with the following name format "_TMPxxxx" where xxxx = numbers.

I assume this is a tmp table created when access is linking a table. I am now trying to delete it with no success.

How can I do it?

Should I use tabledef.connection = "" or something like that ?

Cheers

SK
 
Create an empty database and import everything except this object into it.
 
what happens when you try to delete it? did you get an error message?

try compact/repair
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top