Old form references in MSysQueries and MSysObjects

[Guus2005]

This query show me forms i once had in my Access 2003 database.

SELECT
IIf(Left$([Name],1)="~",Mid$(GetPart([Name],"~",2),5),[Name]) AS Form,
MSysObjects.Owner, MSysObjects.Name, MSysQueries.Attribute,
MSysQueries.Expression, MSysQueries.Flag, MSysQueries.LvExtra,
MSysQueries.Name1, MSysQueries.Name2, MSysQueries.ObjectId, MSysQueries.Order
FROM MSysQueries INNER JOIN MSysObjects ON MSysQueries.ObjectId =
MSysObjects.Id;

For some reason the query reference to the items still exist.
How do i get rid of them?

 

[Allen Browne]

Compact the database.

It's on the Tools menu in A2003.