• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 360
  • Last Modified:

System Object Prefix - What is it?

When I look in the MSysObjects table the name for some of the type 5 objects have a prefix ~sq_.  Since only some and not all names have this prefix, I was curious about its significance.  I also want to relieve myself of the idea that this indicates a problem with the object.
1 Solution
~something means that this is a deleted object (to my knowledge). These objects are "removed" when you compact your database.

It is quite similar of the way files are deleted in Windows. A ~ is put as the first character in the file name and it will no longer appear in the directory. If you however use a disk editing tool you will find it in the File Allocation Table and if it is not too long (or to much activity) since it was deleted, replacin the first character might undelete the file.
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
The ~ character is used to denote temporary objects.

  As Trgve said, it used to mark objects that are about to be deleted.  It's also used for things like saved definitions of SQL strings.

  In a nutshell, anything that Access wants to keep track of but doesn't want to show to the user.

rbrowAuthor Commented:
Thank you.  Compacting the database, did remove the objects.

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now