Your biggest potential problem is your use of Access, which is a single-user DB. Switch to something else more capable.
I'd also advise you to normalise them by splitting it into two tables. You lose nothing by doing so, and gain a lot of flexiblity. Lookups will be lightening-fast as long as the foreign key matching the link to the word in the links table is indexed. You should normalise your tables as much as possible as a matter of good practice. In 99% of cases, normalising to BCNF will be just fine. You only denormalise them when there's some significant performance reason for doing so, which there rarely is. Heed Knuth's words: "Premature optimisation is the root of all programming evil". K. -- Keith Gaughan, Developer Digital Crew Ltd., Pembroke House, Pembroke Street, Cork, Ireland http://digital-crew.com/ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Special thanks to the CF Community Suite Gold Sponsor - CFHosting.net http://www.cfhosting.net Message: http://www.houseoffusion.com/lists.cfm/link=i:4:184034 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
