Access 2000 unstable queries

[Louis1]

I build a query, and find that when I close, and go back to it later,
the query is wrong.

For example, if I use 8 fields, it loses the correct field references,
and instead has 8 occurrences of the first field I select.

I can specify fields like:

Date , Property ,FileID , appraiser, address, jobtype,
lendercasenumber

But, when I go back to it, it is like this:

Date, Date, Date, Date, Date, Date, Date, Date.

I reinstalled, and am using MS Access 2000. I'm reading MS Access 2002
database maintained by a program called "A La Mode Wintotal."

I suppose I should upgrade, but don't really use Access much.

Thanks very much for any insight :)

[Larry Linson]

Have you applied all three Service Packs for Access 2000?

I think you can still obtain the required updates from the Office Update
command button on the Windows Update site. If you are on a dialup
connection, you should search for them, and order the CDs (if still
available... Access 2000 is "out of support", already).

Have you searched the Knowledge Base at http://support.microsoft.com to see
if there is an article on this that indicates either a solution or a
workaround?

If neither of these help, then you may need to consider upgrading. To assure
that a newer version will solve the problem, you can download a trial
version... start at http://office.microsoft.com and I think you'll see a
link to download.

I'm not a fan of Access 2000, but in my admittedly-limited use of it, I
never experienced the phenomenon you describe. That, of course, is not to
say that you are NOT experiencing it, but it might be something unique to
your configuration or software setup.

Larry Linson
Microsoft Access MVP
"Louis1" <louis@_n0sp3m_HoustonBookClub.com> wrote in message
news:51********************************@4ax.com...

I build a query, and find that when I close, and go back to it later,
the query is wrong.

For example, if I use 8 fields, it loses the correct field references,
and instead has 8 occurrences of the first field I select.

I can specify fields like:

Date , Property ,FileID , appraiser, address, jobtype,
lendercasenumber

But, when I go back to it, it is like this:

Date, Date, Date, Date, Date, Date, Date, Date.

I reinstalled, and am using MS Access 2000. I'm reading MS Access 2002
database maintained by a program called "A La Mode Wintotal."

I suppose I should upgrade, but don't really use Access much.

Thanks very much for any insight :)

[Louis1]

Thanks ! This is good info :)

I agree that I should upgrade. It's just that I use
it so little, it's hard to justify financially, but am
so glad there are things to try out first.

Thanks very much for your time and interest !

Louis @ HoustonBookClub.com in Houston, Tx

On Mon, 06 Dec 2004 03:26:18 GMT, "Larry Linson"
<bo*****@localhost.not> wrote:

Have you applied all three Service Packs for Access 2000?

I think you can still obtain the required updates from the Office Update
command button on the Windows Update site. If you are on a dialup
connection, you should search for them, and order the CDs (if still
available... Access 2000 is "out of support", already).

Have you searched the Knowledge Base at http://support.microsoft.com to see
if there is an article on this that indicates either a solution or a
workaround?

If neither of these help, then you may need to consider upgrading. To assure
that a newer version will solve the problem, you can download a trial
version... start at http://office.microsoft.com and I think you'll see a
link to download.

I'm not a fan of Access 2000, but in my admittedly-limited use of it, I
never experienced the phenomenon you describe. That, of course, is not to
say that you are NOT experiencing it, but it might be something unique to
your configuration or software setup.

Larry Linson
Microsoft Access MVP
"Louis1" <louis@_n0sp3m_HoustonBookClub.com> wrote in message
news:51********************************@4ax.com.. .

I build a query, and find that when I close, and go back to it later,
the query is wrong.