How do we search the MS KB for error messages?

M

Margaret Bartley

I used to type in an error message and get a KB article to explain what I'm
doing wrong, and how to do it better.

It's been quite a while since that has worked, and I'm wondering if there's
a website I don't know about.

The particular error I'm trying to figure out is:
"Specify the table containing the records you want to delete"

I'm trying to delete all the records from one table that have a date less
than the matching records in another table.

It seems pretty straight forward, but I can't figure out where to get the
help in the Microsoft website.

Is the Knowledge Base still the repository of help that it used to be?

Many thanks,
Margaret
 
V

Van T. Dinh

Post the relevant details of your Tables and the SQL String of your Delete
Query.

HTH
Van T. Dinh
MVP (Access)
 
M

Margaret Bartley

I don't need help with that specific Delete issue, I figured it out pretty
quickly.

What I was really asking is about the Knowledge Base, itself.
Does it still exist, as a useful tool? If so, where is it? I can't seem to
get any hits when I go into the support.microsoft search form, and search
the KB.

Am I just looking in the wrong place? The problem I stated was just an
example of something that should be in the KB, but I couldn't find it, I got
that there were no matching records. (!)(?)
 
M

Margaret Bartley

That is the exact message
..
I don't think I've gotten a useful hit from the Knowledge Base in several
years.
It used to be a very valuable resource, but it seems pretty useless now. I
was
wondering it maybe Marketing took over, and decided to rename it, or some
other
reason it was hiding around, and I just didn't know where it was.
 
D

Douglas J Steele

Odd. I don't see it, Van. I wonder whether it has something to do with your
locale settings. (I seem to recall that there are differences in terms of
what templates are available based on locale)
 
V

Van T. Dinh

Yep. I always wonder where some of the links take me to whether it is local
in Oz or in the US.
 
M

Margaret Bartley

That's my question.

Several years ago, Microsoft had a wonderful support site, that did a very
good job of
providing KB articles. The current site is pretty useless. I'm wondering
if that previously
great site is hidden somewhere else.
 
V

Van T. Dinh

In my case (Australia), the Microsoft Support Web site was changed about a
year ago to the new fangle-thingy. However, it has recently been changed to
something similar to the one before the above change and I seem to be able
to find most things I want.

I am sure we get different Microsoft Web page as per Doug's post.
 
D

Douglas J. Steele

You still haven't answered my question. WHAT site at Microsoft are you going
to?
 
M

Margaret Bartley

I went to http://support.microsoft.com/search/?adv=1
and entered these values:
Search Product: Access 2000
For "Specify the table containing the records you
want to delete"
[using the quote marks didn't seem to matter]
Show results for: This product only
[another problem - if I say "This product only" I
don't get the other Access answers,
that may be relevant, but if I say "This product
first", I get stuff from Windows
recovery console before Access 97, and all kinds of
irrelevant apps]
Search type: Error message
Using The exact phrase
Modified Any time

I have tried many combinations of results and categories, and I get a
hundred answers every
time, and not a single one even has the error message I entered, much less
is it relevant
to a Delete Query.

Hundreds of false hits. Obviously, I'm missing something. I've been using
the KB for a
decade, I used to rely on it all the time.
 
V

Van T. Dinh

I believe the actual error message is:

"Could Not Delete from Specified Tables"

and if you type the above phrase in the Microsoft Support Search page, it
will the KB 240098.

As a test, I just use some keywords: Delete Query Table and the same article
is included in the returned list.
 
M

Margaret Bartley

No. Here is the SQL:

"DELETE Table1.f2
FROM DeptsByJob INNER JOIN Table1 ON DeptsByJob.Yr = Table1.f2
WITH OWNERACCESS OPTION;"

The error message is as I said:

"Specify the table containing the records you
want to delete"



Van T. Dinh said:
I believe the actual error message is:

"Could Not Delete from Specified Tables"

and if you type the above phrase in the Microsoft Support Search page, it
will the KB 240098.

As a test, I just use some keywords: Delete Query Table and the same
article
is included in the returned list.

--
HTH
Van T. Dinh
MVP (Access)




Margaret Bartley said:
I went to http://support.microsoft.com/search/?adv=1
and entered these values:
Search Product: Access 2000
For "Specify the table containing the records you
want to delete"
[using the quote marks didn't seem to matter]
Show results for: This product only
[another problem - if I say "This product only" I
don't get the other Access answers,
that may be relevant, but if I say "This product
first", I get stuff from Windows
recovery console before Access 97, and all kinds of
irrelevant apps]
Search type: Error message
Using The exact phrase
Modified Any time

I have tried many combinations of results and categories, and I get a
hundred answers every
time, and not a single one even has the error message I entered, much
less
is it relevant
to a Delete Query.

Hundreds of false hits. Obviously, I'm missing something. I've been
using
the KB for a
decade, I used to rely on it all the time.
Click to expand...
Click to expand...
 
Top