Access 97, Office 97, SR2
In testing my groovey little app, I discovered a not so groovey little problem.. To import my data from a previous Access database, I had to change the autonumber field to regular 'Number'. Now, I am unable to change it back.
I vaugly remember being able to use a query to change these entries from the old to the new, but how can it be done? I've tried an update query, but autonumber fields can't be updated.. Please Help! <img src=/S/dizzy.gif border=0 alt=dizzy width=15 height=15>