global search of the MSysQueries table

[ARC]

I wrote a quick routine to search for the text "Mainmenu" in the MSysQueries
table, in the expression field.

I was able to find and alter all occurences of this phrase with the
exception of 3:

Mainmenu found in object ~sq_cfSellOld~sq_ccboContact, ObjectID: -2147483106
Mainmenu found in object ~sq_cfServiceOld~sq_ccboContact,
ObjectID: -2147483074
Mainmenu found in object ~sq_cfServiceOld~sq_clstJobs, ObjectID: -2147483069

The 3 above appear to be pointing to an old form: fSellOld, and fServiceOld

However, those forms no longer exist, so I'm wondering how to remove these
Mainmanu occurrences when I cannot find the object.

Many thanks in advance,
--
Andy

['69 Camaro]

Hi, Andy.

The 3 above appear to be pointing to an old form: fSellOld, and
fServiceOld

However, those forms no longer exist, so I'm wondering how to remove these
Mainmanu occurrences when I cannot find the object.

Compact the database.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

[ARC]

Done that many a time...but to no avail.

Thanks though!
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:Htmyi.5144$ze.650@trnddc07...

Hi, Andy.

>The 3 above appear to be pointing to an old form: fSellOld, and
fServiceOld

However, those forms no longer exist, so I'm wondering how to remove
these Mainmanu occurrences when I cannot find the object.

Compact the database.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

['69 Camaro]

Hi, Andy.

Done that many a time...but to no avail.

Create a new database and import the objects into it from the old database,
one group at a time. First the tables, then the queries, then the forms, et
cetera. Compile the code and compact the database. Do you still see those
embedded queries?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

[ARC]

I haven't had a chance yet, but I'll try your suggestion of just importing
all objects into a blank db. I'm sure that will do the trick.

Thanks again,
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:h1oyi.3626$iA.906@trnddc05...

Hi, Andy.

>Done that many a time...but to no avail.

Create a new database and import the objects into it from the old
database, one group at a time. First the tables, then the queries, then
the forms, et cetera. Compile the code and compact the database. Do you
still see those embedded queries?

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

[Tom van Stiphout]

On Mon, 20 Aug 2007 19:49:50 GMT, "ARC" <an**@andyc.comwrote:

Queries starting with "~sq_" are temporary queries, and can be skipped
when doing an import.
One reason they are created is in the "Query by Form" action.

But then, queries are in the front-end, and don't need to be imported
into the new version, You are releasing the new version, with its set
of queries.

If you are trying to preserve user-created queries, OK, but I would
warn users they should create those in their own MDB (linking to the
same BE).

-Tom.

>I wrote a quick routine to search for the text "Mainmenu" in the MSysQueries
table, in the expression field.

I was able to find and alter all occurences of this phrase with the
exception of 3:

Mainmenu found in object ~sq_cfSellOld~sq_ccboContact, ObjectID: -2147483106
Mainmenu found in object ~sq_cfServiceOld~sq_ccboContact,
ObjectID: -2147483074
Mainmenu found in object ~sq_cfServiceOld~sq_clstJobs, ObjectID: -2147483069

The 3 above appear to be pointing to an old form: fSellOld, and fServiceOld

However, those forms no longer exist, so I'm wondering how to remove these
Mainmanu occurrences when I cannot find the object.

Many thanks in advance,

['69 Camaro]

>I haven't had a chance yet, but I'll try your suggestion of just importing

>all objects into a blank db. I'm sure that will do the trick.

Thanks again,

You're welcome. Since the new database file has its own MSysObjects table,
the ghost entries from the deleted forms' embedded queries shouldn't import
from the original database without those forms.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

['69 Camaro]

Hi, Tom.

Queries starting with "~sq_" are temporary queries, and can be skipped
when doing an import.

His are permanent queries that were embedded for two combo boxes
(cboContact) and a list box (lstJobs) on the two forms, fSellOld and
fServiceOld. Embedded queries are inseparable from the forms during an
import, so if one imports the form, the embedded queries come along, too.
However, the system table, MSysObjects, wasn't updated when the two forms
were deleted, so those three table entries still exist.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

[ARC]

That's what I figured... That for whatever reason, when I deleted the old
versions of the forms, it left some stragglers. Also, how on earth do you
cleanup the old toolbars and shortcut menus? I want/need some, but not all,
otherwise on the importing into a blank db, I would not select the option to
grab toolbars. I see no way in 2007 to modify or even delete, specific older
toolbars.

Andy
"'69 Camaro" <Fo**************************@Spameater.orgZERO_SP AMwrote in
message news:SByyi.2315$jy6.418@trnddc01...

Hi, Tom.

>Queries starting with "~sq_" are temporary queries, and can be skipped
when doing an import.

His are permanent queries that were embedded for two combo boxes
(cboContact) and a list box (lstJobs) on the two forms, fSellOld and
fServiceOld. Embedded queries are inseparable from the forms during an
import, so if one imports the form, the embedded queries come along, too.
However, the system table, MSysObjects, wasn't updated when the two forms
were deleted, so those three table entries still exist.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.

['69 Camaro]

Hi, Andy.

Also, how on earth do you cleanup the old toolbars and shortcut menus?

It's easy enough by using the "Customize..." menu item in older versions of
Access, but I don't have Access 2007, so I don't know what steps for you to
take. Perhaps someone else can advise you. It would probably be best to
start a new thread with this question.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blogs: www.DataDevilDog.BlogSpot.com, www.DatabaseTips.BlogSpot.com
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.