How do we search the MS KB for error messages?

[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

 

[Van T. Dinh]

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

HTH
Van T. Dinh
MVP (Access)

 

[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. (!)(?)

 

[Douglas J. Steele]

Where did you go? I use
http://search.microsoft.com/search/search.aspx?view=msdn&st=a&c=0&s=1

Are you sure that's the exact error message you got? I have to agree, I
didn't get any hits using that text.

 

[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.

 

[Douglas J. Steele]

And is that the same site?

While there are certainly some issues with it, I still find it a useful
tool. On the other hand, I have heard several people saying that they prefer
to use Google, perhaps at http://www.google.com/microsoft.html

 

[Van T. Dinh]

On the RHS of the (advanced) Search page
http://support.microsoft.com/search/?adv=1
there is the Error Message Wizard I often use to check the error number /
message.

 

[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)

 

[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.

 

[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.

 

[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.

 

[Douglas J. Steele]

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

 

[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.

 

[Douglas J. Steele]

Have you tried the URL I suggested?

To save you having to scroll through the whole thread, it was
http://search.microsoft.com/search/search.aspx?view=msdn&st=a&c=0&s=1


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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.

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

 

[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.

 

[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"

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)

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.

 

[Margaret Bartley]

I did try that one, it didn't work. There are several different ways to
query the KB, and they seem to have different results - none of which are
useful.

That's the point of my question- I'm trying to understand the microsoft
on-line support system.

It seems to be toast.
Thanks for you help, though.
Margaret

Have you tried the URL I suggested?

To save you having to scroll through the whole thread, it was
http://search.microsoft.com/search/search.aspx?view=msdn&st=a&c=0&s=1


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

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.

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

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



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.



message And is that the same site?

While there are certainly some issues with it, I still find it a
useful tool. On the other hand, I have heard several people saying
that they prefer to use Google, perhaps at
http://www.google.com/microsoft.html

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



message 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.



message Where did you go? I use
http://search.microsoft.com/search/search.aspx?view=msdn&st=a&c=0&s=1

Are you sure that's the exact error message you got? I have to
agree, I didn't get any hits using that text.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)



message 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. (!)(?)



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




message
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?

 

[Van T. Dinh]

You need to use

DELETE Table1.*