WEIRD ERROR While updating an Access form recordset (prompts for old field)

I have updated the name of a field in the table from which a form and its subform draw information. The recordsource property is empty at design, but is filled in through code. The thing is, there is one field on the table whose name I changed. I updated ALL the objects/forms/components to the new field name, and STILL, when it runs the code line where it feeds the recordsource property of the form, I get an inputbox asking me for the value of the old field that is no longer ANYWHERE in the form. Besides, the query I assign to the form is valid (verified), and it sure does not include that old field name. And the funny thing is, it does not happen every time; just about 80% of the times. It seems as if there is some kind of residue in a cache file or something... I don't understand. Also, I am running that database from a network.
I AM SO SICK OF ACCESS BUGS.... Version 14, and you'd think they would have taken care of this basic stuff....

Anyone has an idea? Thanks so much.
HikarusAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

HikarusAuthor Commented:
PS: I have tried copying all the objects to a new form, and the problem persists. I don't get it :(
0
mbizupCommented:
Open the query that you use for the recordsource.

Right click the window in the query builder and select 'properties'

Are there any occurrences of this field in the property sheet - such as in the filter or order by properties?

Also try making a backup and compact/repairing.
0
HikarusAuthor Commented:
No, there are no references to the old field AT ALL.
In design mode, the property is left empty.
I have already tried compacting/repairing.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Dale FyeCommented:
After making a backup and trying the compact and repair, try decompiling and recompiling the database.  I usually do this via a batch file on my desktop (do it once or twice a week for the app I'm working on at the time).

"C:\Program Files\Microsoft Office\Office12\MSACCESS.EXE" "C:\Users\xxx.yyy\Documents\Work\Access\myDb.accdb" /decompile

The stuff in the first set of quotes is the full path and filename where your version of Access resides (probably not Office12 from your post).  The second is the full path and filename of your database file.

Then recompile do another compact/repair operation and then recompile.

Finally, if that doesn't work, get a copy of Rick Fishers "Find & Replace" and run a search on the old Field name.  You may have it buried in a property (, sort order, order by) of a form, report or query, or in another query somewhere else in your database that is causing the problem.

Dale
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jeffrey CoachmanMIS LiasonCommented:
<I get an inputbox asking me for the value of the old field that is no longer ANYWHERE in the form.>
<No, there are no references to the old field AT ALL.>

It may be there somewhere, you may just not be able to locate it...
;-)
Sometimes references to the old field are lurking in comboboxes, or in your code.

How about just posting a example db that has this issue?

This way we are not just guessing at the solution...

JeffCoachman
0
HikarusAuthor Commented:
That Rick Fishers "Find & Replace" is a tool that Microsoft should have included in Access a looooong time ago!! AWESOME!! <br /><br />Thanks, Dale! :)
0
Dale FyeCommented:
Glad I could help.

F&R is a great program.  I use it all the time, especially when I decide I want to change a field, table, or query name.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.