MS Access 2010 - Add new column

Question

Hi,

I'm working on ms access -2010 32 bit version of MS Access, SQL 2014 ( its a legacy application )

I need to add a new column to an already existing subform, which I was able to do successfully but when I try to save data it doesn't save the data and neither does it throw any error in the newly added field.

What's the usual steps or practice to do so (Sorry. learning my way to MS access)

Thanks for the help!

Answer 1

Hi. Where did the new column you added to the subform come from? Did you add a new column to the table in SQL Server? If so, did you refresh the link to that table in Access?

Answer 2

Yes

Step 1: I added the new column to SQL server database table and to the subform

Step 2: I refreshed the the link.

Step 3: On refreshing the link I could see the newly added column in the link table.

Issue lies when I update the Form it doesn't write/update back to SQL database

If I open up the link table in msaccess and update the value there it updates the database but If I update the form it doesn't update SQL database.

Answer 3

And you only can't update the new column? You have no problems updating the other/previous ones on the subform, correct? If so, check the properties of the new control. You might also try adding a new one, just in case it got corrupted.

Answer 4

Exactly - I'm not able to update the new column but the old column works just fine...

Day 2 Not sure how to get around this :(

I tried deleting the newly added column and recreating but still the same issue.. it looks like I'm missing some step :(

Any help clue is highly appreciated 

Answer 5

If the subform control's SourceObject property is not a table or query, is the ControlSource property of the relevant control in the subform the name of the new column?  Also, if the subform's RecordSource property is a query, does it include the new column?

---

Ken Sheridan, Stafford, England