Old form references in MSysQueries and MSysObjects

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top