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?
8  5032 
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.
fredg <fg******@examp le.invalid> wrote in message news:<di******* *************** ******@40tude.n et>... 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... ma***********@f reenet.co.uk (RibGnaw) wrote in message news:<26******* *************** ****@posting.go ogle.com>... fredg <fg******@examp le.invalid> wrote in message news:<di******* *************** ******@40tude.n et>... 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?
On 15 Sep 2004 15:52:44 -0700, RibGnaw wrote: ma***********@f reenet.co.uk (RibGnaw) wrote in message news:<26******* *************** ****@posting.go ogle.com>... fredg <fg******@examp le.invalid> wrote in message news:<di******* *************** ******@40tude.n et>... 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.
fredg <fg******@examp le.invalid> wrote in message news:<uc******* *************** *******@40tude. net>... On 15 Sep 2004 15:52:44 -0700, RibGnaw wrote:
ma***********@f reenet.co.uk (RibGnaw) wrote in message news:<26******* *************** ****@posting.go ogle.com>... fredg <fg******@examp le.invalid> wrote in message news:<di******* *************** ******@40tude.n et>...
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.
On 16 Sep 2004 15:05:40 -0700, RibGnaw wrote: fredg <fg******@examp le.invalid> wrote in message news:<uc******* *************** *******@40tude. net>... On 15 Sep 2004 15:52:44 -0700, RibGnaw wrote:
ma***********@f reenet.co.uk (RibGnaw) wrote in message news:<26******* *************** ****@posting.go ogle.com>...
fredg <fg******@examp le.invalid> wrote in message news:<di******* *************** ******@40tude.n et>...
> 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 "Alphabetic al List of Products"
report
Alphabetical List of Products
Here is the actual SQL:
SELECT DISTINCTROW Products.*, Categories.Cate goryName
FROM Categories INNER JOIN Products ON Categories.Cate goryID =
Products.Catego ryID
WHERE (((Products.Dis continued)=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.OpenRepor t 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.
"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
"redecorati ng" 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
"Larry Linson" <bo*****@localh ost.not> wrote in message news:<L8N2d.391 $Co1.272@trnddc 02>... "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
"redecorati ng" 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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Allen |
last post by:
Hi All,
Have been using access for some time on a limited basis.I was playing around
with the Northwind database and I have a question for you all. I was looking
at the Products form and it give details about products including how many
are in stock, I picked the product called Chai. By default is says that 39
units in stock. I then go to the orders form and create a new order and use
say 5 , fill in all the fields and save the record. I...
|
by: Jerry Alexander |
last post by:
The Northwind Order Entry Application database is great!
-----------------------------------------
But one thing is lacking: Real-time Stock Qty calculation!
-----------------------------------------
I know that this topic has been discussed over & over in forums, but I
have yet to find anyone that has shown the following:
-----------------
1) Linking Allen Browne's code to Northwind? then an
2) Inventory report to show Products &...
|
by: xtra |
last post by:
Hi Folk
I looked at the Northwind Sample Database for the first time recently and I
was just wondering why they made it so ugly. If northwind is supposed to be
inspiring to young and hopeful access programmers then why does it look
straight out of an 1984 slapstick? MS Corp surely must have a couple of
capable designers to make things look pretty. Did I offend anyone? It is
just my opinion, i may be wrong so do not take it personally...
|
by: dennist685 |
last post by:
Can't open Northwind
I remembered doing walkthrough using Northwind. However it wasn't an http
project but a file project using the development server. Northwind allowed
me to add, edit and insert, and the web page looked fine.
I opened a simple project just to see whether I could get my sqlserver on
the internet. (vs studio 2005, sqlserver 2005)
|
by: JohnnyBoy |
last post by:
I am learning to program C++ .net and am having difficulty with one of the
exercises and wondered if someone could help?
I am including the code for a console app I wrote according to the exercise
that is supposed to create a connection to the
Northwind.mdb database. I modified the code for the ConnectionString to
include the path to where I found Northwind.mdb
to be located on my machine. When I run the program, I get the following...
| | |
by: |
last post by:
I am try this example on vb express 2005:
http://msdn2.microsoft.com/en-US/library/system.windows.forms.datagridviewcomboboxcolumn.aspx
but it keeps giving me an error about the data source to northwind database. I installed the SQL2000SampleDb.msi file, then ran this command at the prompt:
SQLCMD -E -S computerName\SqlExpress -i instnwnd.sql
with my computer name. Can anyone help a noob out here. Many thanks
*** Posted via a free...
|
by: Harlan Messinger |
last post by:
I installed the Northwind database in my SQL Server developer version,
added to the server logins, and in OSQL ran
use Northwind
GO
grant all to
GO
These executed without error. But my test page is being denied access.
|
by: podx |
last post by:
I am trying to connect to SQL 7.0 northwind database via visual studio
2005. But I can't open the connection. I get an error saying remote
access is not allowed. But the remote access is ok. I can used the same
login and connect to the sql server via enterprise manage.
SqlConnection conn = new SqlConnection("Data
Source=(sqlserver:1433);Initial Catalog=Northwind;User
ID=me;Password=mypassword");
The above is the string I am trying to...
|
by: Alberto |
last post by:
I have a script of the database Northwind for sql server 2000 but now I'd
like to use it in the sqlserver express of the visual studio 2005.
How can execute this script to create northwind in the sqlserver express?
Thank you very, very much.
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
