Prev: show erorr:out of memory when creart form or qurey
Next: Luis resume
From: ahmed tharwat ahmed on 23 Jan 2010 06:07
Dear,

I need your help for find a field autonumber automatically
To delete it and re build it automatic
And I call it maintenance the mdb application
I wait your help
With my best regards
Ahmed tharwat


From: Allen Browne on 23 Jan 2010 06:31
The simplest way to do this would be to create a new table, and import the
data from your old table (with an Append query.) Once you've verified the
data is okay, you can delete the old table, compact the database, and then
rename the new one to the old name.

Be careful though: if the autonubmer is primary key, and other tables relate
to it, you will lose touch with which record relates to which.

If you are asking how to programmatically find the autonumber field, see:
http://allenbrowne.com/func-DAO.html#GetAutoNumDAO
http://allenbrowne.com/func-ADOX.html#GetSeedADOX

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"ahmed tharwat" <ahmed tharwat(a)discussions.microsoft.com> wrote in message
news:4844FC8B-939B-4555-A743-39A0FEAB1616(a)microsoft.com...
> Dear,
>
> I need your help for find a field autonumber automatically
> To delete it and re build it automatic
> And I call it maintenance the mdb application
> I wait your help
> With my best regards
> Ahmed tharwat

 | 
Pages: 1
Prev: show erorr:out of memory when creart form or qurey
Next: Luis resume