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 9 3058
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.
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,
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.
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.
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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 ...
|
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 ...
|
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...
|
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...
|
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....
|
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...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
|
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...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
|
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...
| |