View Single Post
  #7  
Old September 10th, 2004, 03:19 AM
Allen Browne
external usenet poster
 
Posts: n/a
Default

If you really want to recreate the table each time, how about including an
empty copy of the table in your database, and using CopyObject?

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

"Tim Ferguson" wrote in message
...
"Bryan Hughes" wrote in
:

My only problem is that I need the AutoNumber field to
set back to zero before each call. This could happen up 5 to 10 times
per user session. Is there a way to do this, or is there a better
solution?


Need?? or would like it to..? Remember that ANs are not reliable record
counters; just identifiers. If you _have_ to control what value an
autonumber takes, then you probably should not be using an autonumber.

It is easy enough to reset the starting seed back to zero by emptying the
table and compacting the mdb, but this obviously involves closing the
file.
Does that conflict with what you call a "session"? You may have to provide
(i.e. program) a different solution.

B Wishes


Tim F