<div>
 The ~ character is used to denote temporary objects.<br />
<br />
&nbsp; As Trgve said, it used to mark objects that are about to be deleted. &nbsp;It's also used for things like saved definitions of SQL strings.<br />
<br />
&nbsp; In a nutshell, anything that Access wants to keep track of but doesn't want to show to the user.<br />
<br />
JimD.
</div>


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.

JimD.

<div>
Thank you. &nbsp;Compacting the database, did remove the objects.
</div>


Thank you.  Compacting the database, did remove the objects.

<div>
<div class="content wysiwyg-content">
When I look in the MSysObjects table the name for some of the type 5 objects have a prefix ~sq_. &nbsp;Since only some and not all names have this prefix, I was curious about its significance. &nbsp;I also want to relieve myself of the idea that this indicates a problem with the object.
</div>
</div>


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.

System Object Prefix - What is it?

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.