sistemalan
Registered User.
- Local time
- Today, 23:49
- Joined
- Jun 19, 2009
- Messages
- 77
Hi all,
I have an issue which surely is relatively common, however I have struggled to find an answer. I have built databases for 3 similar projects (after school music clubs). The first one was built in Access 2003. The other 2 in Access 2013. I'm self taught, but have learned a great deal about database design between databases 1 and 3, and now I'd like to upgrade the older 2, to take advantage of improvements I've added to the new one.
Structurally they are relatively similar, but the main issue I have is that Primary keys on tables such as ChildID on table T_Children, InstrumentId on T_Instruments, AdultID on T_Adults etc are all Autonumber fields.
This means I can't simply copy and paste existing data into a blank version of the new database.
So what do I do? :banghead:
Was it bad practice to use autonumber fields as primary keys on these tables? How do I get around this, and what steps should I take to make future upgrades easier?
Many Thanks for your time, wisdom and understanding.
Alan
I have an issue which surely is relatively common, however I have struggled to find an answer. I have built databases for 3 similar projects (after school music clubs). The first one was built in Access 2003. The other 2 in Access 2013. I'm self taught, but have learned a great deal about database design between databases 1 and 3, and now I'd like to upgrade the older 2, to take advantage of improvements I've added to the new one.
Structurally they are relatively similar, but the main issue I have is that Primary keys on tables such as ChildID on table T_Children, InstrumentId on T_Instruments, AdultID on T_Adults etc are all Autonumber fields.
This means I can't simply copy and paste existing data into a blank version of the new database.
So what do I do? :banghead:
Was it bad practice to use autonumber fields as primary keys on these tables? How do I get around this, and what steps should I take to make future upgrades easier?
Many Thanks for your time, wisdom and understanding.
Alan