Search results

Hello ALL, I want to know how to reset (to start again from 1) my primary key field. As an example i have the "Customers" table with the field "customerID" as PK now i entered many values (20) then i deleted them but i want to start again and the "customerID" value starts with 21 i understand...

I hope I'm posting in the right place, if no let me know where to put this post. I'm trying to make a database for my customers to enter information related to them and what they bought from me to be able after that to make some statistics and analyze.. So the first Table I made is: PART I...

I would like to know if there is a maximum nb of columns to use in a table or at least a prefered max nb. For example i have a table "customers" and inside i have "name" "last name" "age" "gender"..and so on is there a limit? By the way i'm using access 2007 Thx for the explanation in advance.