Software

Question

Locked

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

By frueldistributa ·
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 conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

No you've missed something

by Tony Hopkinson In reply to Issues After Changing a f ...

Are you using predefined queries from VBA.
e.g. OrderQuery is Select [Order Number] From [Orders]
and then VBA is doing Select Fom OrderQuery Where [Order Number] > 10000.

If so you might need to go and rebuild them with the new field name.

It's like using a vew in a stored procedure and changing the view, you have to force the SP to recompile to pick up you the new version.

Related Discussions

Related Forums