Re: A bug in MS Access

Hi Allen,
Thank you for clarifying internal working of Access. I faced this problem
when I was using ADO.Net and MS Access. In the delete query condtion, my
friend used a non existing column mistakenly("empid" instead of "emp_id").
It didn't throw any exception for the invalid column name and deleted all
rows. When I tried in this MS Access directly it was prompting for the value
for invalid column and the if I am inputing value all columns got deleted. I
thought this is a bug and searched for the stage to report this.Atlast, I
posted this in gotdotnet messageboard and I got this link from one of the
reply. I thought this will be useful for others if they face this problem and
posted this. Thanks a lot for clarifying.

Thanks and regards,
Rajeev

"Allen Browne" wrote:

> Rajeev2005, you are very welcome to post your experiences with Access here.
> But I still cannot demonstrate the problem you describe.
>
> The only cases where I can imagine this to be the case would be:
>
> a) You executed the query, and it popped up a dialog asking for the value
> for empid. You typed in 10 as the value. In this case, Access will
> understand emp10 to be equal to 10 for all records, and will therefore
> delete all records.
>
> b) You previously had a field that was named or captioned empid in this
> table. You have not disabled Name AutoCorrect, and so Access still has that
> name associated with something else in this table.
>
> c) The database is corrupt (such as a faulty index), leading to the loss of
> records.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "rajeev2005" <rajeev2005@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:B83F8F5C-20C3-49B2-9F52-B7ABA915F4FC@xxxxxxxxxxxxxxxx
> >I found this bug accidentally when I was developing an application 6 months
> > before and I couldn't find a forum to report this bug. I got this link
> > from
> > Gotodotnet Message board to report this bug.
> >
> > I tried the following steps just before to reconfirm this. And the result
> > was same.
> > I created a table in design mode "Details"
> >
> > Columns DataType
> >
> > ID AutoNumber
> > Name Text
> > Address Text
> >
> >
> > Inserted many rows.
> >
> > and executed the following query
> >
> > "delete * from Details where empid=10". Here empid is a non existing
> > column.
> >
> > All rows got deleted. Why to report a bug without purpose?
> >
> > The MS Access version: Microsoft Access2002(10.2616.3501)SP-1
> >
> > "rajeev2005" wrote:
> >
> >> Hi,
> >> I noticed a bug in MS Access long back. But I couldn't report that to
> >> Microsoft as I was not knowing whom to report. So, I am using this
> >> message
> >> board thread for that.
> >>
> >> The details of the bug :
> >>
> >> I created a table ADDRESSDETAILS with following Columns
> >> ADDRESSID Number(3),NAME TEXT(50),EMAILADDRESS TEXT(100)
> >>
> >> I inserted many rows and I tried the delete query "DELETE * FROM
> >> ADDRESSDETAILS WHERE ID=10".
> >> All the rows from the table were deleted. If you try to delete * using a
> >> condition with a non existing column all raws are getting deleted. I seen
> >> this in many versions of MS Access.
> >> I haven't tried this with MS Access latest version. Please do the needful
> >> if
> >> this is a valid bug.
> >>
> >>
> >> ----------------
> >> This post is a suggestion for Microsoft, and Microsoft responds to the
> >> suggestions with the most votes. To vote for this suggestion, click the
> >> "I
> >> Agree" button in the message pane. If you do not see the button, follow
> >> this
> >> link to open the suggestion in the Microsoft Web-based Newsreader and
> >> then
> >> click "I Agree" in the message pane.
> >>
> >> http://www.microsoft.com/office/community/en-us/default.mspx?mid=39452c17-4dad-4ecf-b29e-facd75554eb7&dg=microsoft.public.access.modulesdaovba
>
>
>
.