Charlotte Foust
cfoust at infostatsystems.com
Tue May 3 17:43:40 CDT 2005
You create a new field with the new name, append the old data to it and then drop the old field. Charlotte Foust -----Original Message----- From: Pedro Janssen [mailto:pedro at plex.nl] Sent: Tuesday, May 03, 2005 2:45 PM To: AccessD at databaseadvisors.com Subject: [AccessD] changing fieldname Hello All, can i change a fieldname of a table with a definition query and ALTER TABLE tablename ALTER COLUMN ? If not can it been done in sql or in code and how?? Pedro Janssen -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com