How do you change the Field Size property in Access 2002
Posted on 2011-10-24
I'm attempting to import data from a SQL Server database into Access 2002. It exports out of SQL Server just fine except the Field Size property of all the keyed fields is "Replication ID" - not a term I'm familiar with. Once it's in Access, you cannot change the property if there are records in the table. Neither can you run an INSERT query into a new table with identical fields if the new table doesn't also have Replication ID in the same fields. All of the records will transfer except for those fields. For example, if the source table has a field named "CLIENT" whose field size is set to Replication ID and the new table - also with a field named "CLIENT" has it's field size property set to anything but Replication ID, that column in the new table will be blank.
This is a critical project I need a resolution to and any Expert with knowledge in this area sharing his/her experience will be greatly appreciated.