Rest data from tables
in [Form]
|
Prev: remain on record that I was editing in a form after requery
Next: Populate text boxes from a list box
From: Highlight between 3 fields on 11 Mar 2010 16:17 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 11 Mar 2010 17:46 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 12 Mar 2010 04:48 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 12 Mar 2010 11:49 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 12 Mar 2010 18:25
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 |