Skip to main content
Inspiring
October 19, 2006
Question

Delete all records ASP/VBS Access

  • October 19, 2006
  • 2 replies
  • 367 views
Hi,

Is it possible to delete all records that match a textfield

i.e. I have a text field on a form and I would like to delete all records in
the database table that match the textfield in a column.

Using ASP/VBS MS Access

Regards,

Sanj



This topic has been closed for replies.

2 replies

Inspiring
October 19, 2006

DELETE FROM tablename
WHERE column = 'value'

This is very basic SQL so I would strongly advise you to look into the
courses that Lionstone pointed out to give yourself a good grounding.
HTH
Cheers,
http://robgt.com/ [Tutorials and Extensions]
Firebox stuff: http://robgt.com/firebox
Skype stuff: http://robgt.com/skype
SatNav stuff: http://robgt.com/satnav



Inspiring
October 19, 2006
www.sqlcourse.com
www.sqlcourse2.com

F1 in Access will help, too.


"Sanj" <webuser@mm.com> wrote in message
news:eh6fsg$5k3$1@forums.macromedia.com...
> Hi,
>
> Is it possible to delete all records that match a textfield
>
> i.e. I have a text field on a form and I would like to delete all records
> in the database table that match the textfield in a column.
>
> Using ASP/VBS MS Access
>
> Regards,
>
> Sanj
>
>
>