If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rest data from tables
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 |
#2
|
|||
|
|||
Rest data from tables
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" wrote in message ... 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 |
#3
|
|||
|
|||
Rest data from tables
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. |
#4
|
|||
|
|||
Rest data from tables
On Fri, 12 Mar 2010 01:48:01 -0800, Highlight between 3 fields
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] |
#5
|
|||
|
|||
Rest data from tables
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 |
Thread Tools | |
Display Modes | |
|
|