trouble creating columns in my table; Access renames my column for me!

[lauerj]

So in the access application I inherited all I am trying to do is add a few columns to a table - 'customer_notes' and access is getting all crazy on me...

I am trying to add 2-3 columns to this table and have them update when the user types text into the same form that already captures "Notes" and "ActionPlan". For some reason whenever I create a new field in table/design view (text, memo, anything ) and save the table and reopen it, it has renamed the column I just created as "Gen_KlAG2MAP" and assigned a number datatype to it. Whenever I try to enter anything into this new column, I get the message "Control Can't Be Edited; it's bound to replication system column 'Gen_KlAG2MAP'.

All I am trying to do is add a few columns to the table....any idea what is going on??

the table I am working with has the following design:

Customer Name | Text (Primary Key)
PlanYear | Text (Primary Key)
Notes | Memo
ActionPlan | Memo

What do I need to do to add the following columns and not have access change the column name and restrict me from entering data?

Entitlement | memo (or text)
RenewalDate | date
OtherEvents | memo (or text)

 

[MichaelRed]

GUESSING here!

The db is a member of a replica database -and it is NOT the master.

If the "Guess" is correct, you cannot (at least directly) change any of the table properties (not the field names, data types, lengths (for Text fields) and or modify indicies ...). Somewhere in the world there is a "MASTER" db, and it has the somewhat limited capability to synchronize the data between the two copies ... but not to do so between altered versions ...

MichaelRed
m.red@att.net

Searching for employment in all the wrong places