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...
