A lot of "documents" named as ~sq_

[Alp Bekisoglu]

Hi Experts,

I happen to have about 30+ "documents" or objects named as "~sq_........"
when I do a SaveAsText on all. I also see them in queries collection query.
They are not visible in the query window.
Is there a way to get rid of these? And why did I get them in the first
place. due to something done wrong?

Thanks in advance.

Alp

 

[Paul Johnson]

You don't want to get rid of these. These are the saved SQL statements
behind every form, report, and combobox control in your application. If you
look more carefully at their names, you will see that QueryDefs named
~sq_fFormName have the SQL that your form [FormName] has in it, and
~sq_rReportName for reports, and ~sq_c(etc.) for comboboxes. Unless you
don't like the queries your application has in place to make a form or
report work, you shouldn't be bothered by their existence in the QueryDefs
collection.

Paul Johnson

 

[Nikos Yannacopoulos]

Alp,

If this is what I think it is, it's not necessarily your fault, it's most
likely Access leaving rubbish behind through the development of your
database. The best way to get a clean database is to rename the existing one
to a different name, create a new, blank one with the name of the original
and inport all objects from the original. This process will not import the
rubbish, and you will have a fresh database that is exactly the same, apart
from the rubbish.

HTH,
Nikos

 

[Nikos Yannacopoulos]

Oops! Apparently I was way off here, so disregard my posting!

 

[Alp Bekisoglu]

Thank you Paul. I was in the opinion that my FE was getting bloated.

Alp

You don't want to get rid of these. These are the saved SQL statements
behind every form, report, and combobox control in your application. If you
look more carefully at their names, you will see that QueryDefs named
~sq_fFormName have the SQL that your form [FormName] has in it, and
~sq_rReportName for reports, and ~sq_c(etc.) for comboboxes. Unless you
don't like the queries your application has in place to make a form or
report work, you shouldn't be bothered by their existence in the QueryDefs
collection.

Paul Johnson

Hi Experts,

I happen to have about 30+ "documents" or objects named as "~sq_........"
when I do a SaveAsText on all. I also see them in queries collection query.
They are not visible in the query window.
Is there a way to get rid of these? And why did I get them in the first
place. due to something done wrong?

Thanks in advance.

Alp

 

[Paul Johnson]

My wife is of the opinion that my FE is getting a bit bloated, too. I
should spend less time at the computer and more time on the treadmill...

Thank you Paul. I was in the opinion that my FE was getting bloated.

Alp

You don't want to get rid of these. These are the saved SQL statements
behind every form, report, and combobox control in your application. If you
look more carefully at their names, you will see that QueryDefs named
~sq_fFormName have the SQL that your form [FormName] has in it, and
~sq_rReportName for reports, and ~sq_c(etc.) for comboboxes. Unless you
don't like the queries your application has in place to make a form or
report work, you shouldn't be bothered by their existence in the QueryDefs
collection.

Paul Johnson

Hi Experts,

I happen to have about 30+ "documents" or objects named as "~sq_........"
when I do a SaveAsText on all. I also see them in queries collection query.
They are not visible in the query window.
Is there a way to get rid of these? And why did I get them in the first
place. due to something done wrong?

Thanks in advance.

Alp

 

[Alp Bekisoglu]

My wife is of the opinion that my FE is getting a bit bloated, too. I
should spend less time at the computer and more time on the treadmill...

Thank you Paul. I was in the opinion that my FE was getting bloated.

Alp

You don't want to get rid of these. These are the saved SQL statements
behind every form, report, and combobox control in your application.

If
you

look more carefully at their names, you will see that QueryDefs named
~sq_fFormName have the SQL that your form [FormName] has in it, and
~sq_rReportName for reports, and ~sq_c(etc.) for comboboxes. Unless you
don't like the queries your application has in place to make a form or
report work, you shouldn't be bothered by their existence in the QueryDefs
collection.

Paul Johnson

Hi Experts,

I happen to have about 30+ "documents" or objects named as "~sq_........"
when I do a SaveAsText on all. I also see them in queries collection
query.
They are not visible in the query window.
Is there a way to get rid of these? And why did I get them in the first
place. due to something done wrong?

Thanks in advance.

Alp