Northwind 2007

[Meredith9053]

Have just bought Office 2007, and had a look at Northwind 2007. Funny enough
it is EXACTLY what I want for a small program to manage my
customers/products. Can anyone tell me if it is possible to reset Northwind
2007 to no data?

Is this possible?

I dont have the smarts to make a program, been trying for some time and get
so lost with it towards the end! This would make my life so much more simple!

 

[Wayne-I-M]

Hi

I have a copy of vista (on a stand alone laptop) just to review. I have not
looked at the Northwind that ships with AC-2K7 but with most DB's you can
simple delete all the records (or import tables, queries, etc into a new DB).
But the point is that the Northwind DB is there to show you what is possible
and give you one method (there are always others) of doing various tasks.

If you are going to use a DB to run any part of a commercial operation there
should "always" be someone who at least understands how it works, this could
be an outside contractor or an in-house IT dept - or even one person, but
there should always be someone who can look at a problem when it crops up
(which it will) and fix it.

TO depend on a programme and assume it will not require up keeping would be
a mistake. One day a user will do something (press a button, open a form,
print a report, etc etc etc) and it will not work. This “will†happen when
it is vital that it is done “now†and with no one to look at the problem and
be at least able to offer some hope of fixing it, you will have problem ???.
Access is not like word or excel where you can simply plug it in a use it.
AC requires some input to make it work as “you†need it to do.

There are zillions of people who will be able to construct a DB that will do
what you need (this could – if you want – be based on the Northwind model)
and they will be able to look at problems when they arise and fix them.

I would strongly suggest you don’t even start inputting data into a cleared
copy of the Northwind DB.

Good luck

 

[Tom Wickerath]

Hi Meredith,

All you need to do is delete all the records from each table. I haven't
become familiar enough with this new version of Northwind--it has several
more tables than past versions--so I'm not prepared at this time to tell you
which order you need to clear the tables in. You may find, if referential
integrity (RI) is enforced, but cascade delete has not been enabled, that you
will encounter some errors if attempting to delete records first from a
"parent" table. In that case, just select a different table. Eventually, you
should be able to find the correct child tables to delete the records from
first.

If you run into trouble clearing the tables, post back, and I will fire up a
copy of Northwind 2007 to help you determine how to proceed with deleting
records.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[scubadiver]

The best thing to do is simply look at the table relationships and this will
determine which order you delete the information.

Having said that I agree with Wayne. You are better off designing a DB that
suits your own needs rather than trying to take a short cut unless Northwind
is perfectly ideal.

 

[Jeff Conrad [MSFT]]

It's a whole lot easier than you might think.

Follow these steps:
1. Make sure you have Enabled the Content to run VBA code and all macros
2. Click the top of the Navigation Pane and select Object Type under
Navigate to Category
3. Click the top of the Navigation Pane and select Macros under Filter by
Group
4. Double click on the macro object called Delete All Data
5. Click Yes on the confirmation message to delete all the data
6. You might want to compact the database after this: Office Button | Manage
| Compact and Repair Database

That's it!

--
Jeff Conrad - Access Junkie - MVP Alumni
SDET - XAS Services - Microsoft Corporation

Co-author - Microsoft Office Access 2007 Inside Out
Presenter - Microsoft Access 2007 Essentials
http://www.accessmvp.com/JConrad/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

 

[Bill Sheng]

Here are the steps:
1. Open Access and create a new Access database.
2. On the tabbed menu, click "External Data". In the "Import" section, select Access.
3. Browse to Northwind 2007 database and check the radio button for import tables, queries...
4. A new window "Import Objects" will be displayed. Go ahead and select all the objects in each tabbed section.
5. Click on "Options>>" and select "definition only" in the imort table options. You might also select all import options such as relationship ...
6. Click OKAY.

7. After everything is imported, you'll need to open the "Employee List" table and enter a new employee before you can logon to the familiar Northwind Logon form, and the Northwind "Home page".

8. Go the the Navigation Pane and locate the Employee List table, open it, and creat a new entry.

9. Locate the "Login Dialog" table in the Navigation Pane and open it. Now you can select the new emplyee you just entered and logon to the original Homepage.

Hope this helps.

EggHeadCafe - .NET Developer Portal of Choice
http://www.eggheadcafe.com

 

[Meredith9053]

Thanks so much for your help. I have decided you are so definately right and
I will not use northwind, for the fear of something going wrong down the
track, and we know it will!

Thanks so much for your time.
Cheers
Meredith