473,574 Members | 2,704 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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~s q_ccboContact, ObjectID: -2147483106
Mainmenu found in object ~sq_cfServiceOl d~sq_ccboContac t,
ObjectID: -2147483074
Mainmenu found in object ~sq_cfServiceOl d~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 3067
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.orgZE RO_SPAMwrote in
message news:Htmyi.5144 $ze.650@trnddc0 7...
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.orgZE RO_SPAMwrote in
message news:h1oyi.3626 $iA.906@trnddc0 5...
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.com wrote:

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~s q_ccboContact, ObjectID: -2147483106
Mainmenu found in object ~sq_cfServiceOl d~sq_ccboContac t,
ObjectID: -2147483074
Mainmenu found in object ~sq_cfServiceOl d~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.orgZE RO_SPAMwrote in
message news:SByyi.2315 $jy6.418@trnddc 01...
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
5094
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 the days before PHP got object-oriented features. For instance we currently have:
14
1830
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 (Employee LIKE ?) AND (Period_End_Date = ?) ORDER BY I then get my Data by the following:
10
10799
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 The command was processed as an SQL statement because it was not a valid Command Line Processor command. During SQL processing it returned:...
2
2346
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 application at the same time. Today, we are using a permanent DB2 table and getting all kinds of locking even with row level locking on. In addition,...
2
1663
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 other is a String. Currently they both work as I like and I can get my data as I want. What I'm intersted in is seeing HOW I do a Global search for...
4
3553
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. Does anyone know if this can be done? Thanks
4
3714
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 even possible?
9
17541
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 temp tables to store intermediate results than using "WITH cluase" in our queries. Where does DB2 store the intermediate results if the query uses...
6
2221
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 button that does this all for me. In my head the method should go something like this:
0
7814
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7736
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8070
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
5631
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5309
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3750
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3760
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2252
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
0
1072
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.