Access 2000 field renaming prblm
Hi all,
I use to have a field named RDI_ID, later on I decided to change the name to RDI to make things easier.
I have several macros in XL pulling recordsets (using rst.open sql), but they stopped working, even though I have changed that field name to RDI in the code as well.
Curiously, they do work when I change the code back to the old name, being RDI_ID. I have been looking at that field propriety and it is named RDI. Did I miss a change somewhere?
That table has no relationship whatsoever. I have no report in the DB but I do have a few queries that I'm not really using, should I delete them?
Help plzz.
Re: Access 2000 field renaming prblm
Either you still have some data somewhere that is referring the the original field name. Thouroughly check your excel workbook for any code referencing that field. Then look in Access.
These macros in Excel are stored in the workbook, template, personal macros , etc?
Re: Access 2000 field renaming prblm
Oh God I found my mistake, it's so stupid that I don't really want to elaborate.
Can't believe I wasted 2 hrs on this.
Rob, my sincere apologies, I should have seen this by myself.
Re: Access 2000 field renaming prblm
No worries. Usually a second pair of eyes helps when you have been reviewing the same issue for a while. ;)
Hope that I was able to shed some light on your solution. :)