Changing the Primary Key Autonumber

  • Thread starter Thread starter Annie
  • Start date Start date
A

Annie

Hi
I have a database that I have cleared out all data and I want to use the
same design for my information this year. I have deleted all records but my
autonumber is now showing as 74 for my first record on the form - can I
change this back to 1 fairly easily.

Many thanks
 
hi Annie,
I have a database that I have cleared out all data and I want to use the
same design for my information this year. I have deleted all records but my
autonumber is now showing as 74 for my first record on the form - can I
change this back to 1 fairly easily.
Click to expand...
Run compact and repair. This should reseed the auto-increment.


mfG
--> stefan <--
 
if you used a real database-- like SQL Server, then you cuold simply
TRUNCATE tblLOOKUP and it would reset that one table.

if you rely on Jet, then you need to take the database offline to do
something like this (which is a side effect of running a compact and
repair)
 
a said:
if you used a real database-- like SQL Server, then you cuold simply
TRUNCATE tblLOOKUP and it would reset that one table.
Click to expand...
Sorry, boy, a table can only be truncated if no foreign key on it
exists... a lookup table without makes no sense at all.


mfG
--> stefan <--
 
dude I'm the only certified DBA around here.

what you say is correct-- but that doesn't mean I should be using Jet.

ADP kicks ass.. anyone who isn't using it is just plain stupid
 
Back
Top