By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,327 Members | 2,627 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,327 IT Pros & Developers. It's quick & easy.

ANY Idea how to flush all data in an access DB or one of its tables?

P: n/a
Hi5
Hi,
I am new to MS access I have lots of experience in Mysql in which there
arer some tools like sql yog to manage the database.I am looking for
the function in access to clear all data eneterd into a database table.

I think there must be a very straight forward way to do this,Any Idea?

Many thanks

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a

"Hi5" <fk***************@yahoo.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
Hi,
I am new to MS access I have lots of experience in Mysql in which there
arer some tools like sql yog to manage the database.I am looking for
the function in access to clear all data eneterd into a database table.

I think there must be a very straight forward way to do this,Any Idea?

Many thanks


Create a Delete query using the following SQL statement:

DELETE * FROM YourTable
Nov 13 '05 #2

P: n/a
Hi5
Didn't even think of that!!!
Many Thanks!!!

Nov 13 '05 #3

P: n/a
"Jeff Smith" <No****@Not.This.Address> wrote in
news:d8**********@lust.ihug.co.nz:
"Hi5" <fk***************@yahoo.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...
Hi,
I am new to MS access I have lots of experience in Mysql in which
there arer some tools like sql yog to manage the database.I am
looking for the function in access to clear all data eneterd into
a database table.

I think there must be a very straight forward way to do this,Any
Idea?


Create a Delete query using the following SQL statement:

DELETE * FROM YourTable


This is actually very fast, even for tables with large numbers of
records, because, if I'm remembering my reading from the Jet DB
Engine Programmer's Guide, deleting everything from a table actually
simply deletes the whole table and recreates it.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.