Rest data from tables

[Highlight between 3 fields]

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

 

[George Hepworth]

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"

 

[Highlight between 3 fields]

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.

 

[John W. Vinson]

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.

 

[Highlight between 3 fields]

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