i wanted to change the case in my linked tables. i exported each table in Excel and did work on each table to make the case from caps to proper.
I then imported each excel file back into my Access database. As each file imported, I was asked about the primary key. Knowing my linked tables relied on that primary key, i chose to use my own existing ID key.
Now, I cannot add any records. It is telling me my primary key is reading null. If I allow Access to determine my primary key, my tables will not link. Have I really blown it here?
I then imported each excel file back into my Access database. As each file imported, I was asked about the primary key. Knowing my linked tables relied on that primary key, i chose to use my own existing ID key.
Now, I cannot add any records. It is telling me my primary key is reading null. If I allow Access to determine my primary key, my tables will not link. Have I really blown it here?