i dont know why you want to do that but in access you always have to define a key, if you dont do that access will define a key by itself. Now if you have a row of numbers and you want to add one, for example you have 1,5,9,15,17 and you want to add 10 then just make it on the last row and sort it on the key or one any colum you want, save it and problem fixed i think... but my view is limited since i dont know your motivation of inserting a new record half way a table...