Using Templates and Sample Databases

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jen0214 - 19 Mar 2007 17:28 GMT

I need help. Does anyone know if there is an easy way to use templates? I
need to delete just the sample data from a template downloaded from
Microsoft.com. Is it at all possible to delete just the sample data from a
sample database in Access (i.e. Northwid.mdb)? Seems like this would be
simple to do, but isn't.

Thank you for any help you can give.

Jen0214

Reply to this Message

Rick B - 19 Mar 2007 18:20 GMT

It is very easy to do. Just open the tables, select all the records, and
hit delete.

I believe you would only need to do this for about 6 tables (Orders, Order
Details, Products, Shippers, and Suppliers).

Signature

Rick B

>I need help. Does anyone know if there is an easy way to use templates? I
> need to delete just the sample data from a template downloaded from
[quoted text clipped - 5 lines]
>
> Jen0214

Reply to this Message

Joan Wild - 19 Mar 2007 18:25 GMT

Backup the database.
Open it and open the Order Details table; hit Ctrl-a and the delete key
Open Orders; hit ctrl-a and then delete.
repeat for Customers, Employees, Shippers, Products, Suppliers, Categories,
in that order.

Since the cascade delete is not set on the relationships among these tables,
you need to start at the many side of any relationship...i.e. you can't
delete Customers until their orders are deleted and you can't delete the
orders until the order details are deleted,etc. If you open the
relationship window in any of the templates, you'll see which table you need
to start with.

Signature

Joan Wild
Microsoft Access MVP

>I need help. Does anyone know if there is an easy way to use templates? I
> need to delete just the sample data from a template downloaded from
[quoted text clipped - 5 lines]
>
> Jen0214

Reply to this Message

Hunter57 - 19 Mar 2007 20:49 GMT

> Backup the database.
> Open it and open the Order Details table; hit Ctrl-a and the delete key
[quoted text clipped - 23 lines]
>
> - Show quoted text -

Here is an easy way to do it.

Create a new blank Database. Then click on the Menu Bar File>Get
External Data>Import. Select the Database you want to copy from.
Click the Tables Tab. Then click on the Options button on the Import
Window. Under Import Tables, click Definition Only. If you want, you
can also copy the Relationships, Menus and Toolbars, and the Specs.
You will have all of the tables with the relationships, default
values, etc. without any data. All of the tables will be empty.

You can also import Forms, Queries, Modules, etc.

Happy Computing,

Hunter57

Reply to this Message

Joan Wild - 19 Mar 2007 22:05 GMT

> Here is an easy way to do it.
>
[quoted text clipped - 7 lines]
>
> You can also import Forms, Queries, Modules, etc.

That will work in this case, but not all.

Signature

Joan Wild
Microsoft Access MVP

Reply to this Message

Jen0214 - 30 Mar 2007 18:22 GMT

Thank you all. This helped greatly.

Jen0214

> > Here is an easy way to do it.
> >
[quoted text clipped - 9 lines]
>
> That will work in this case, but not all.

Reply to this Message