A lot of "documents" named as ~sq_

  • Thread starter Thread starter Alp Bekisoglu
  • Start date Start date
A

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
 
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
 
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
 
Thank you Paul. I was in the opinion that my FE was getting bloated.

Alp

Paul Johnson said:
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

Alp Bekisoglu said:
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
Click to expand...
Click to expand...
 
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...

Alp Bekisoglu said:
Thank you Paul. I was in the opinion that my FE was getting bloated.

Alp

Paul Johnson said:
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

Alp Bekisoglu said:
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
Click to expand...
Click to expand...
Click to expand...
 
:-)


Paul Johnson said:
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...

Alp Bekisoglu said:
Thank you Paul. I was in the opinion that my FE was getting bloated.

Alp

Paul Johnson said:
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.
Click to expand...
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top