reset the autonumber field in Access 2000 
Author Message
 reset the autonumber field in Access 2000

Q1:
how can i reset the autonumber in a field back to 1 in a Access2000
database?

Q2:
how can i copy and paste a without using Access 2000 (using codes)? when i
paste the table, i want only the structure and i do not want the data inside
the table..Currently i am using Access 2000 to do it....how can i do it with
say a query or using vb6???

pls help...



Sun, 16 Jan 2005 20:51:40 GMT  
 reset the autonumber field in Access 2000
1. Compact the database. Of course, the value of the autonumber field
shouldn't matter: it's sole purpose is to serve as a (practically
guaranteed) unique value that can be used as a primary key, and it does that
whether it's 1 or 32404.

2. Look into using ADOX or DAO to create tables.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele



Quote:
> Q1:
> how can i reset the autonumber in a field back to 1 in a Access2000
> database?

> Q2:
> how can i copy and paste a without using Access 2000 (using codes)? when i
> paste the table, i want only the structure and i do not want the data
inside
> the table..Currently i am using Access 2000 to do it....how can i do it
with
> say a query or using vb6???

> pls help...



Mon, 17 Jan 2005 07:25:36 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Resetting Autonumber fields?

2. Resetting autonumber fields using vba

3. Resetting AutoNumber fields

4. Resetting AutoNumber field back to 1

5. Reset autonumber fields

6. Reset Autonumber in access

7. autonumber corruption in access 2000

8. VB6 Access 2000 AutoNumber and SELECT

9. Getting Autonumber for new row (Access 2000 and ADO)

10. Referencing Access 2000 Field Names and Values in Word 2000

11. concacenating a single field from an Access 2000 database while in Word 2000

12. Accessing the autonumber field in access

 

 
Powered by phpBB® Forum Software