Re: A bug in MS Access

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


.