Old form references in MSysQueries and MSysObjects

  • Thread starter Thread starter Guus2005
  • Start date Start date
G

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;

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