Northwind traders

[aomhussien]

how can i delete all data from the northwind database sample that
comes with msaccess?
i want to adapt it to my own use!!!!

[tina]

you can open each table in Datasheet view, click the gray box in the upper
left corner of the "grid" to highlight all the records, and press the Delete
key on your keyboard.

or you can create a Delete query, add each table to the Design window *in
turn*, add the asterisked (*) row from the table to the grid and run the
query.

or you can write VBA code to loop through the tables, executing a SQL
statement to the delete the records on each table in turn.

hth
<ao********@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...

how can i delete all data from the northwind database sample that
comes with msaccess?
i want to adapt it to my own use!!!!

[Tom van Stiphout]

On Sun, 24 Jun 2007 14:01:10 GMT, "tina" <no****@address.comwrote:

And remember to do this in such an order that you don't violate
Referential Integrity: for example you cannot delete Customers until
you have deleted Orders. You cannot delete Orders until you have
deleted OrderDetails.

-Tom.

>you can open each table in Datasheet view, click the gray box in the upper
left corner of the "grid" to highlight all the records, and press the Delete
key on your keyboard.

or you can create a Delete query, add each table to the Design window *in
turn*, add the asterisked (*) row from the table to the grid and run the
query.

or you can write VBA code to loop through the tables, executing a SQL
statement to the delete the records on each table in turn.

hth
<ao********@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegr oups.com...

>how can i delete all data from the northwind database sample that
comes with msaccess?
i want to adapt it to my own use!!!!

[tina]

note the important point Tom brought up, that i had left out; it applies to
all three options i suggested in my previous post.

as a fourth option, you can: open a new, blank database (don't forget to
turn OFF the Name Autocorrect option, if you're using A2000 or newer).
import all the objects from the sample database; in the Import Objects
dialog box, click on Options and set the Import Tables option to Definition
Only.

hth
"tina" <no****@address.comwrote in message
news:GO*******************@bgtnsc04-news.ops.worldnet.att.net...

you can open each table in Datasheet view, click the gray box in the upper
left corner of the "grid" to highlight all the records, and press the

Delete

key on your keyboard.

or you can create a Delete query, add each table to the Design window *in
turn*, add the asterisked (*) row from the table to the grid and run the
query.

or you can write VBA code to loop through the tables, executing a SQL
statement to the delete the records on each table in turn.

hth
<ao********@gmail.comwrote in message
news:11**********************@g4g2000hsf.googlegro ups.com...

how can i delete all data from the northwind database sample that
comes with msaccess?
i want to adapt it to my own use!!!!

[missinglinq via AccessMonster.com]

And before you do anything, make a backup copy, in case you need to refer to
it in the future!

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via http://www.accessmonster.com