> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 14 July 2003 14:01 > To: [EMAIL PROTECTED] > Access will prob > not like me changing the datatypes becuase of relationships.
Yeah as I thought Access isn't letting me change the data-types without me deleting all of the relationships first, I have 23 tables and about 35 relationships. Does anyone know of a way of changing the datatypes (from AutoNumbers to Numbers (keeping it as a primary key)) without having to delete all of my relationships etc? If not then I'll stick with AutoNumbers Cheers, Chris British Telecommunications plc Registered office: 81 Newgate Street London EC1A 7AJ Registered in England no. 1800000 This electronic message contains information from British Telecommunications plc which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. Activity and use of the British Telecommunications plc E-mail system is monitored to secure its effective operation and for other lawful business purposes. Communications using this system will also be monitored and may be recorded to secure effective operation and for other lawful business purposes. Any views expressed in this email do not reflect those of BT and any of partners and assosiates. Responsiblity for the opinions expressed are those of the sender only -- ** Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] For human help, e-mail: [EMAIL PROTECTED]
