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

Northwind Database

P: n/a
Long, long ago when Access 97 first hit the streets a sample database
called Northwind was shipped with it. At that time a number of
articles had been posted on the correct procedure to remove all the
sample data. Does anyone out there still have this information?
Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
On 12 Sep 2004 13:24:58 -0700, RibGnaw wrote:
Long, long ago when Access 97 first hit the streets a sample database
called Northwind was shipped with it. At that time a number of
articles had been posted on the correct procedure to remove all the
sample data. Does anyone out there still have this information?


Create and name a brand new database.
Click on File + Get External Data + Import.
Navigate to the Northwind database.
Select it.
When the Import Dialog opens ...
On each tab, click on Select All.
Then click on Options.
In the Import area click on Relationships.
In the Import Table area click on Definition Only.
Click OK.
Save the new database.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #2

P: n/a
fredg <fg******@example.invalid> wrote in message news:<di****************************@40tude.net>.. .
On 12 Sep 2004 13:24:58 -0700, RibGnaw wrote:
Long, long ago when Access 97 first hit the streets a sample database
called Northwind was shipped with it. At that time a number of
articles had been posted on the correct procedure to remove all the
sample data. Does anyone out there still have this information?


Create and name a brand new database.
Click on File + Get External Data + Import.
Navigate to the Northwind database.
Select it.
When the Import Dialog opens ...
On each tab, click on Select All.
Then click on Options.
In the Import area click on Relationships.
In the Import Table area click on Definition Only.
Click OK.
Save the new database.


Many thanks Fred...
Nov 13 '05 #3

P: n/a
ma***********@freenet.co.uk (RibGnaw) wrote in message news:<26**************************@posting.google. com>...
fredg <fg******@example.invalid> wrote in message news:<di****************************@40tude.net>.. .
On 12 Sep 2004 13:24:58 -0700, RibGnaw wrote:
Long, long ago when Access 97 first hit the streets a sample database
called Northwind was shipped with it. At that time a number of
articles had been posted on the correct procedure to remove all the
sample data. Does anyone out there still have this information?


Create and name a brand new database.
Click on File + Get External Data + Import.
Navigate to the Northwind database.
Select it.
When the Import Dialog opens ...
On each tab, click on Select All.
Then click on Options.
In the Import area click on Relationships.
In the Import Table area click on Definition Only.
Click OK.
Save the new database.


Many thanks Fred...


Umm, after trying the method above I now get the following error
whenever the ORDERS button is pressed from the main switchboard " The
Microsoft Jet database engine cannot find the input table or query
'Orders Qry' Make sure it exist and that its name is spelt correctly.

I have checked that all the tables and queries etc that are present in
Nwind are also in the new database, but there does not appear to be a
query named 'Orders'.

Anyone got any ideas on what may be causing this, or alternatively
anyone got the Nwind database without the data that is fully
functional?
Nov 13 '05 #4

P: n/a
On 15 Sep 2004 15:52:44 -0700, RibGnaw wrote:
ma***********@freenet.co.uk (RibGnaw) wrote in message news:<26**************************@posting.google. com>...
fredg <fg******@example.invalid> wrote in message news:<di****************************@40tude.net>.. .
On 12 Sep 2004 13:24:58 -0700, RibGnaw wrote:

> Long, long ago when Access 97 first hit the streets a sample database
> called Northwind was shipped with it. At that time a number of
> articles had been posted on the correct procedure to remove all the
> sample data. Does anyone out there still have this information?

Create and name a brand new database.
Click on File + Get External Data + Import.
Navigate to the Northwind database.
Select it.
When the Import Dialog opens ...
On each tab, click on Select All.
Then click on Options.
In the Import area click on Relationships.
In the Import Table area click on Definition Only.
Click OK.
Save the new database.


Many thanks Fred...


Umm, after trying the method above I now get the following error
whenever the ORDERS button is pressed from the main switchboard " The
Microsoft Jet database engine cannot find the input table or query
'Orders Qry' Make sure it exist and that its name is spelt correctly.

I have checked that all the tables and queries etc that are present in
Nwind are also in the new database, but there does not appear to be a
query named 'Orders'.

Anyone got any ideas on what may be causing this, or alternatively
anyone got the Nwind database without the data that is fully
functional?


I followed my instructions above and the Orders Form does have as it's
record source "Orders Qry".

There is no actual "Orders Qry" query as such.
There is the record source SQL, used in the Orders form, that has been
named "Orders Qry".

Open the Orders form in design view.
Look at the the record source property. It may or may not actually say
'Orders Qry'. If it does, click on the button with the 3 dots that
appears on that line.
You should have a Query grid with the Customer table and the Order
Table showing. Click on the bang and all of the order records should
appear (of course after you have entered some records).

If there is nothing there, write Orders Qry on the Record Source line.
Then click on the button with the 3 dots.
Next add the 2 tables. Make sure the relationship is Customer Table
CustomerID 1 side to Order Table CustomerID many side.

Drag all of the Order table fields onto the grid.
Drag all of the Customer table fields onto the grid EXCEPT Fax, Phone,
ContactName, ContactID, and CompanyID.

Save the query.
The record source should now say Order Qry and the query is as above.

Save the form.
Enter sample data in the other tables as needed.
Then open the Orders Form.

--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #5

P: n/a
fredg <fg******@example.invalid> wrote in message news:<uc*****************************@40tude.net>. ..
On 15 Sep 2004 15:52:44 -0700, RibGnaw wrote:
ma***********@freenet.co.uk (RibGnaw) wrote in message news:<26**************************@posting.google. com>...
fredg <fg******@example.invalid> wrote in message news:<di****************************@40tude.net>.. .
On 12 Sep 2004 13:24:58 -0700, RibGnaw wrote:

> Long, long ago when Access 97 first hit the streets a sample database
> called Northwind was shipped with it. At that time a number of
> articles had been posted on the correct procedure to remove all the
> sample data. Does anyone out there still have this information?

Create and name a brand new database.
Click on File + Get External Data + Import.
Navigate to the Northwind database.
Select it.
When the Import Dialog opens ...
On each tab, click on Select All.
Then click on Options.
In the Import area click on Relationships.
In the Import Table area click on Definition Only.
Click OK.
Save the new database.

Many thanks Fred...


Umm, after trying the method above I now get the following error
whenever the ORDERS button is pressed from the main switchboard " The
Microsoft Jet database engine cannot find the input table or query
'Orders Qry' Make sure it exist and that its name is spelt correctly.

I have checked that all the tables and queries etc that are present in
Nwind are also in the new database, but there does not appear to be a
query named 'Orders'.

Anyone got any ideas on what may be causing this, or alternatively
anyone got the Nwind database without the data that is fully
functional?


I followed my instructions above and the Orders Form does have as it's
record source "Orders Qry".

There is no actual "Orders Qry" query as such.
There is the record source SQL, used in the Orders form, that has been
named "Orders Qry".

Open the Orders form in design view.
Look at the the record source property. It may or may not actually say
'Orders Qry'. If it does, click on the button with the 3 dots that
appears on that line.
You should have a Query grid with the Customer table and the Order
Table showing. Click on the bang and all of the order records should
appear (of course after you have entered some records).

If there is nothing there, write Orders Qry on the Record Source line.
Then click on the button with the 3 dots.
Next add the 2 tables. Make sure the relationship is Customer Table
CustomerID 1 side to Order Table CustomerID many side.

Drag all of the Order table fields onto the grid.
Drag all of the Customer table fields onto the grid EXCEPT Fax, Phone,
ContactName, ContactID, and CompanyID.

Save the query.
The record source should now say Order Qry and the query is as above.

Save the form.
Enter sample data in the other tables as needed.
Then open the Orders Form.


Getting nearer,
The Order now works and the customer information is taken from the
customer table.
Now I have another problem, in the Products form, when you press
either the Preview Product List or Output to HTML buttons the error
appears that it can't find the 'Alphabetical list of Products'I tried
the method of ensuring that it pointed to the report, after checking
what the original Nwind database pointed to and they are the same.
Did the import action miss something important that I can copy from
the original?
Thanks.
Nov 13 '05 #6

P: n/a
On 16 Sep 2004 15:05:40 -0700, RibGnaw wrote:
fredg <fg******@example.invalid> wrote in message news:<uc*****************************@40tude.net>. ..
On 15 Sep 2004 15:52:44 -0700, RibGnaw wrote:
ma***********@freenet.co.uk (RibGnaw) wrote in message news:<26**************************@posting.google. com>...
fredg <fg******@example.invalid> wrote in message news:<di****************************@40tude.net>.. .
> On 12 Sep 2004 13:24:58 -0700, RibGnaw wrote:
>
> > Long, long ago when Access 97 first hit the streets a sample database
> > called Northwind was shipped with it. At that time a number of
> > articles had been posted on the correct procedure to remove all the
> > sample data. Does anyone out there still have this information?
>
> Create and name a brand new database.
> Click on File + Get External Data + Import.
> Navigate to the Northwind database.
> Select it.
> When the Import Dialog opens ...
> On each tab, click on Select All.
> Then click on Options.
> In the Import area click on Relationships.
> In the Import Table area click on Definition Only.
> Click OK.
> Save the new database.

Many thanks Fred...

Umm, after trying the method above I now get the following error
whenever the ORDERS button is pressed from the main switchboard " The
Microsoft Jet database engine cannot find the input table or query
'Orders Qry' Make sure it exist and that its name is spelt correctly.

I have checked that all the tables and queries etc that are present in
Nwind are also in the new database, but there does not appear to be a
query named 'Orders'.

Anyone got any ideas on what may be causing this, or alternatively
anyone got the Nwind database without the data that is fully
functional?


I followed my instructions above and the Orders Form does have as it's
record source "Orders Qry".

There is no actual "Orders Qry" query as such.
There is the record source SQL, used in the Orders form, that has been
named "Orders Qry".

Open the Orders form in design view.
Look at the the record source property. It may or may not actually say
'Orders Qry'. If it does, click on the button with the 3 dots that
appears on that line.
You should have a Query grid with the Customer table and the Order
Table showing. Click on the bang and all of the order records should
appear (of course after you have entered some records).

If there is nothing there, write Orders Qry on the Record Source line.
Then click on the button with the 3 dots.
Next add the 2 tables. Make sure the relationship is Customer Table
CustomerID 1 side to Order Table CustomerID many side.

Drag all of the Order table fields onto the grid.
Drag all of the Customer table fields onto the grid EXCEPT Fax, Phone,
ContactName, ContactID, and CompanyID.

Save the query.
The record source should now say Order Qry and the query is as above.

Save the form.
Enter sample data in the other tables as needed.
Then open the Orders Form.


Getting nearer,
The Order now works and the customer information is taken from the
customer table.
Now I have another problem, in the Products form, when you press
either the Preview Product List or Output to HTML buttons the error
appears that it can't find the 'Alphabetical list of Products'I tried
the method of ensuring that it pointed to the report, after checking
what the original Nwind database pointed to and they are the same.
Did the import action miss something important that I can copy from
the original?
Thanks.


The record source for the Preview Product List is done the same way as
the orders form.
Name the record source property of the "Alphabetical List of Products"
report
Alphabetical List of Products

Here is the actual SQL:

SELECT DISTINCTROW Products.*, Categories.CategoryName
FROM Categories INNER JOIN Products ON Categories.CategoryID =
Products.CategoryID
WHERE (((Products.Discontinued)=No));

I have no idea why these didn't copy over when you imported the
objects from the Northwind database.

As you practice a bit more, if you find this kind of error again,
check that the record source of the report is there. You can compare
it against your full Northwind database for the actual SQL.

If it was me, I would actually create a named query using that above
SQL and simply set the report record source to that query, as is done
in other reports.

Remember, Northwind is an example database, not necessarily an
efficient fully functional one. It uses different methods to
accomplish the same goal. For instance, the Output to HTML report
button uses DoCmd.OpenReport in it's click event, while the Preview
button uses a Hyperlink SubAddress to open the same report in a
different view.

By the way, Access ships with several other database templates (File +
New + General Database + Databases tab), as well as a Solutions.mdb
and an Orders.mdb. It would be worth your while to examine these
others as well as Northwind.
They should all be on your computer (or on your program CD).
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
Nov 13 '05 #7

P: n/a
"fredg" wrote
By the way, Access ships with several
other database templates (File +
New + General Database + Databases
tab), as well as a Solutions.mdb
and an Orders.mdb. It would be worth
your while to examine these others as
well as Northwind.
They should all be on your computer
(or on your program CD).


Fred, since Access 2000, it has been necessary to download the
"Solutions.MDB" -- and then it disappeared from Microsoft's site during some
"redecorating" there. It is currently, temporarily housed at
http://www.mvps.org/access/downloads/bapp2000.exe.

I concur that it is very, very useful as a source of "how do I..."
information.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #8

P: n/a
"Larry Linson" <bo*****@localhost.not> wrote in message news:<L8N2d.391$Co1.272@trnddc02>...
"fredg" wrote
> By the way, Access ships with several
> other database templates (File +
> New + General Database + Databases
> tab), as well as a Solutions.mdb
> and an Orders.mdb. It would be worth
> your while to examine these others as
> well as Northwind.
> They should all be on your computer
> (or on your program CD).


Fred, since Access 2000, it has been necessary to download the
"Solutions.MDB" -- and then it disappeared from Microsoft's site during some
"redecorating" there. It is currently, temporarily housed at
http://www.mvps.org/access/downloads/bapp2000.exe.

I concur that it is very, very useful as a source of "how do I..."
information.

Larry Linson
Microsoft Access MVP


Thanks for the help guys, not managed to sort the problem yet but will keep trying.

Mark.
Nov 13 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.