473,320 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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
Aug 20 '07 #1
9 3058
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.
Aug 20 '07 #2
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.


Aug 20 '07 #3
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.
Aug 20 '07 #4
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.


Aug 21 '07 #5
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,
Aug 21 '07 #6
>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.
Aug 21 '07 #7
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.
Aug 21 '07 #8
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.


Aug 21 '07 #9
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.
Aug 21 '07 #10

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

88
by: Tim Tyler | last post by:
PHP puts most of its functions into a big flat global namespace. That leads to short function names - but creates a namespace minefield for programmers. Lots of the functions are legacies from...
14
by: Toby | last post by:
I've a DataAdapter with: SELECT ID, Employee, , Period_End_Date, Job, Description, Exported, Units, Cost_Code, Category, Class, Chargeout_Level, PayID, Rate FROM tblTimeEntry WHERE ...
10
by: Ranga | last post by:
I was unable to run the statement "CREATE GLOBAL TEMPORARY TABLE" on unix version of DB2, it gave the follwing error db2 => create global temporary table temp ( OGI_SYS_NR char(8) ) DB21034E ...
2
by: Chuck Crews | last post by:
I am interested in declaring a global temporary table within an application. The application processes 1 set of 600 or less rows each iteration. Multiple programs can and do call this one...
2
by: JohnT | last post by:
Okay... I'm using VB.net (2003) and I am accessing an MS Access DB file. I have two DataAdapters that I use to search for specific info. The two of them are similar except one is a Date, the...
4
by: RoadRunner | last post by:
Hi, I have a question. I am asked to produce a global search of a given corporate name, in more that one database. Each database has different table names and different field names in the tables....
4
by: ManningFan | last post by:
Let's see if I can ask this without confusing you or myself. I need to be able to type a tablename into a box, and search my entire database to see which queries are using that table. Is this...
9
by: Veeru71 | last post by:
Can someone point me to good documentation on 'WITH clause" ? (I couldn't get much out of Queries section from SQL Reference manual). We are getting better performance when we explicity use global...
6
by: simon.robin.jackson | last post by:
Ok. I need to develop a macro/vba code to do the following. There are at least 300 corrections and its expected for this to happen a lot more in the future. Therefore id like a nice...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.