Upgrade

C

Claire

Have recently upgraded from office 97 to 2003.
Since converting my dbase, it no longer generates an automatic ID number in
the primary key, however, it will let me manually enter one. Any ideas?
 
J

Jackie L

Sounds like you lost your autonumber characteristics. Look at that field in
the table design and see if it is number instead. In order to repair/replace
an autonumber field, you would have to create a new field and then delete the
old. That could cause lots of problems if you have other tables linking to
that primary key.

You should consider leaving the table as a number (if indeed it is), and
changing your "autonumber" to be generated off the form instead of by the
table itself if you are using a form to enter the data.

Let us know.
 
M

Matilda

Claire said:
Have recently upgraded from office 97 to 2003.
Since converting my dbase, it no longer generates an automatic ID number in
the primary key, however, it will let me manually enter one. Any ideas?
Click to expand...
Thanks for the warning, Jackie. I have several mission critical Access
applications in 97 that crash, fall over, refuse to open"this database is in
exclusive mode....." etc all of which amount to the fact that they are
unuseable without completely rebuilding. Aaaaarrrgh!! A pox on microsft,
nothing better to look forward to in 2003
 
C

Claire

Hi Jackie

Thanks for the response - I don't think I explained my problem clearly
enough previously;

the ID no. in my 'table' is the primary key and is set as a number (always
has been - i've checked all these settings in access 97).
When i enter info in my 'form', a unique ID no. was automatically generated
Since my convertion to access 2003 (which i know regret!), it no longer
generates an ID no., however I can manually enter one - this is a pain 'cos I
have to keep checking what my last number and make sure no-one else is using
the dbase before I enter any info - it's used accross a network and ends up
locking everyone out otherwise!

If you've got any other idea's I'd love to hear them - I really appreciate
your input.

Thanks

Claire
 
Top