ExcelBanter - View Single Post - Old form references in MSysQueries and MSysObjects

Guus2005

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

Code:

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;

How do i get rid of them?