Bill,
Thanks for the heads up on the AutoCorrect tracking issue. I always turn that off, however, I have noticied that from time to time, a query will ask for an old paramter that is no longer in the query and I could never figure out why. Now I'm thinking that someone made a change to a query while AutoCorrect was still on.
However, due to database security settings, I can't always import everything into a clean database. I have usually just recreated the query. Is there another way to fix this issue?
John F
--- In MS_Access_Professionals@yahoogroups.com, mrsgoudge <no_reply@...> wrote:
>
> Thanks Bill! AutoCorrect Tracking was off. Will import tomorrow.
> REALLY appreciate your input!
> Connie
>
> --- In MS_Access_Professionals@yahoogroups.com, "Bill Mosca" wrote:
>
> Connie
>
> First thing...make sure you have turned off the Name AutoCorrect Tracking. This causes more harm than good.
>
> Next, import everything into a new, blank database.
>
> Hopefully, that will chase out all the gremlins.
>
> Bill Mosca
>
> --- In MS_Access_Professionals@yahoogroups.com, mrsgoudge wrote:
>
> This is a continuation of my previous post but with a different twist.
>
> Now I'm getting a different set of records :-( . It now has an error for the same couple where previously the query returned an old unended lookingevent in addition to a current one and now it's returning two of the current new ones. Should be returning one current one only.
>
> I have noticed that when I've renamed a query today I'll sometimes get a message for a parameter from the old name and when I search the SQL the old name is not there. Cut and pasted the SQL to a new query and no problem.
>
> I'm also getting a "too many databases open" message when I do a certain sequence of form openings, entries.
>
> I have decompiled and then compacted and repaired. Hasn't helped.
>
> What's happening???? Any thoughts on how to work through this?
> Connie
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (4) |
Tidak ada komentar:
Posting Komentar