Ive migrated from Access to SQL Server 2012 but when I link my table back into the Access db I have some field names that are 64characters long, which becuase they have spaces and other special characters in them encloses them in square brackets e.g. [this field]. However the square brackets are included in the character count when creating the linked table into Access it truncates the last 2 characters off the field name e.g. [this fie].
Anyone got a way around this to ensure all 64 characters are shown in the table?
tia
M