From: Highlight between 3 fields on
Hello

I am thinging to use the sample Northwind 2007 as test on my work.
I wonder how can I rest all data tables etc that contain to let the ID start
from No 1
So customer, suplier, order, purchase will start with ID 1
From: George Hepworth on
What exactly would be the goal here? Are you emptying out the sample data
for your own purposes?

Even if that is the case, the Primary Key fields (I.e., the "ID" fields)
should not need to be reset to 1. The Primary Key only needs to be unique to
fulfill it's function.

However, this KB article http://support.microsoft.com/kb/812718 describes
steps to reseed autonumbers .

HTH

George

"Highlight between 3 fields"
<Highlightbetween3fields(a)discussions.microsoft.com> wrote in message
news:90AF5F41-1CFA-47AB-8C43-5A110ACCD973(a)microsoft.com...
> Hello
>
> I am thinging to use the sample Northwind 2007 as test on my work.
> I wonder how can I rest all data tables etc that contain to let the ID
> start
> from No 1
> So customer, suplier, order, purchase will start with ID 1

From: Highlight between 3 fields on
Hello

Thanks for your replay, but when I rest all ID and wrote few products, so it
not work to make purchase!

I even create new MS Access database and import the sample with all
information, But I choose only Definition (no date).
So this way dosent work when makes purchase. It show massage that is wrong
on relationship, though I don't see any wrong on relation. It looks as it is
on the sample, but not work.
From: John W. Vinson on
On Fri, 12 Mar 2010 01:48:01 -0800, Highlight between 3 fields
<Highlightbetween3fields(a)discussions.microsoft.com> wrote:

>Hello
>
>Thanks for your replay, but when I rest all ID and wrote few products, so it
>not work to make purchase!
>
>I even create new MS Access database and import the sample with all
>information, But I choose only Definition (no date).
>So this way dosent work when makes purchase. It show massage that is wrong
>on relationship, though I don't see any wrong on relation. It looks as it is
>on the sample, but not work.

If you would like help solving the problem please post the definition of your
tables: fieldnames and datatypes, and the relationship between the tables.
--

John W. Vinson [MVP]
From: Highlight between 3 fields on
Hello

Thank you very much for helping.

It is not easy for me to explain the sample that I don't know it as well and
I was thinking to test on our job and see if we will be satisfed with it or
not.

Anyway, I will search after similar to this kind of sample that is easyer to
rest data from tables.

Thanks a lot