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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

System table delete access

Status
Not open for further replies.

DrewConn

Programmer
Jan 8, 2002
167
US
I have found two reports in my db that are nameed ~tmp followed by some letters and numbers. I need to delete these reports. Repair DB did not work. They do not show up in the reports window.

Also when I go into the sysobjects table, I cant delete them due to a "no delete permission on msobjects" error.

How can I get rid of these two reports?

Thanks.
 
Drew, I'm not sure if this will work but it might be worth a shot. I have run into a similar problem before where there were forms in the database that I wasn't able to delete. What I did to get around this, was to create forms that had the same names as the forms I wanted to delete, which would overwrite them. I would then be able to delete the forms the forms I just created.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top