vb code to split table

[RUDOLFSUN]

Hi does any one know a vb code to split a table using an auto number field

say I had 2000000 records and I wanted to choose any table in a form and hit a button that would split the table in two table 1 and table 2

any help would be great

thanks

 

[RuralGuy]

That seems like a counter productive thing to do. Putting the table in its own mdb, yes. Why do you believe you need to do such a thing?