Issues After Changing a field Name in a table (Access) - TechRepublic
Question
August 14, 2009 at 11:50 AM
frueldistributa

Issues After Changing a field Name in a table (Access)

by frueldistributa . Updated 16 years, 11 months ago

Hello, I am not a big MS Access fan, and rarely have to utilize it. Therefore I have limited knowledge of its operation.

I’m dealing with this odd issue. After changing a field name in a table, followed by changing the field name in sql strings in my vba code. I keep getting run-time errors telling me I’m missing a value or a parameter.

The sql string worked before, and all I did was change the field name. It blows me my mind why it wouldn’t work anymore. I tried restarting access, my computer, et cetera.

So when you change a field name in a table in access do you have to restart something? Are all the initial field names stored anywhere.

Anyone have an idea?

Thanks.

This discussion is locked

All Comments