I have made an Access-solution wich now is ready to be installed to our 

customers servers. Only this still borthering is that I have written lot 

of test-data in the all tables in this database and if I just delete them, 

the autonumber-fields do not go the zero.



Do you have any suggestions how to delete all rows and also set autonumber 

to beginning? 



I remember once reading something like I should first rename a table, then 

copy it and I would get a choise wheather I want to copy only structure or 

data also. Last I would name the new table with the original name. 



I'm afraid that if I would do theese things, maybe the connections to 

other tables, queries, forms and reports would get damaged.



If you have any ideas I would preciate it,

Sanna

Just delete the autonumber field and create a new none.  but, make sure 

that you redo

your relationship (if you have the autonumber field as your primary id).



>>> "Sanna Korpela" <sanna.m.korpela@l...> 08/23 2:29 PM >>>

I have made an Access-solution wich now is ready to be installed to our

customers servers. Only this still borthering is that I have written lot

of test-data in the all tables in this database and if I just delete them,

the autonumber-fields do not go the zero.



Do you have any suggestions how to delete all rows and also set autonumber

to beginning?



I remember once reading something like I should first rename a table, then

copy it and I would get a choise wheather I want to copy only structure or

data also. Last I would name the new table with the original name.



I'm afraid that if I would do theese things, maybe the connections to

other tables, queries, forms and reports would get damaged.



If you have any ideas I would preciate it,

Sanna

I think I remember something about if you delete all the records then do

a repair and compact it resets all of the autonumbers.



-----Original Message-----

From: Sanna Korpela [mailto:sanna.m.korpela@l...] 

Sent: Thursday, 23 August 2001 2:29 PM

To: Access

Subject: [access] deleting all testrows from database



I have made an Access-solution wich now is ready to be installed to our 

customers servers. Only this still borthering is that I have written lot



of test-data in the all tables in this database and if I just delete

them, 

the autonumber-fields do not go the zero.



Do you have any suggestions how to delete all rows and also set

autonumber 

to beginning? 



I remember once reading something like I should first rename a table,

then 

copy it and I would get a choise wheather I want to copy only structure

or 

data also. Last I would name the new table with the original name. 



I'm afraid that if I would do theese things, maybe the connections to 

other tables, queries, forms and reports would get damaged.



If you have any ideas I would preciate it,

Sanna

After you delete all your test data, then compact the database.  This

will reset all your autonumber fields to 0.



John Ruff - The Eternal Optimist  :-)



-----Original Message-----

From: Sanna Korpela [mailto:sanna.m.korpela@l...] 

Sent: Thursday, August 23, 2001 2:29 PM

To: Access

Subject: [access] deleting all testrows from database



I have made an Access-solution wich now is ready to be installed to our 

customers servers. Only this still borthering is that I have written lot



of test-data in the all tables in this database and if I just delete

them, 

the autonumber-fields do not go the zero.



Do you have any suggestions how to delete all rows and also set

autonumber 

to beginning? 



I remember once reading something like I should first rename a table, then 

copy it and I would get a choise wheather I want to copy only structure or 

data also. Last I would name the new table with the original name. 



I'm afraid that if I would do theese things, maybe the connections to 

other tables, queries, forms and reports would get damaged.



If you have any ideas I would preciate it,

Sanna

If you do a compact/repair after you delete all the rows, the autonumbers

should start back out at zero.  



But be careful about caring too much about the values of autonumbers--they

probably shouldn't be treated as though they contain any actual information

(apart from maybe keeping rough track of the order of record creation).  You

cannot assign or re-assign values to them, and you will likely end up with

holes in the sequence...



HTH,



-Roy



-----Original Message-----

From: Sanna Korpela [mailto:sanna.m.korpela@l...]

Sent: Thursday, August 23, 2001 7:29 AM

To: Access

Subject: [access] deleting all testrows from database





I have made an Access-solution wich now is ready to be installed to our 

customers servers. Only this still borthering is that I have written lot 

of test-data in the all tables in this database and if I just delete them, 

the autonumber-fields do not go the zero.



Do you have any suggestions how to delete all rows and also set autonumber 

to beginning? 



I remember once reading something like I should first rename a table, then 

copy it and I would get a choise wheather I want to copy only structure or 

data also. Last I would name the new table with the original name. 



I'm afraid that if I would do theese things, maybe the connections to 

other tables, queries, forms and reports would get damaged.



If you have any ideas I would preciate it,

Sanna

Hi Sanna,



Delete all test data and then complact the database.  When you compact 

empty database all autonumbers reset to zero.



JohnF



>>> sanna.m.korpela@l... 24/08/2001 0:29:27 >>>

I have made an Access-solution wich now is ready to be installed to our

customers servers. Only this still borthering is that I have written 

lot

of test-data in the all tables in this database and if I just delete 

them,

the autonumber-fields do not go the zero.



Do you have any suggestions how to delete all rows and also set autonumber



to beginning?



I remember once reading something like I should first rename a table, 

then

copy it and I would get a choise wheather I want to copy only structure 

or

data also. Last I would name the new table with the original name.



I'm afraid that if I would do theese things, maybe the connections to

other tables, queries, forms and reports would get damaged.



If you have any ideas I would preciate it,

Sanna