By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,729 Members | 1,398 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,729 IT Pros & Developers. It's quick & easy.

Access 2000 unstable queries

P: n/a
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 :)
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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 :)

Nov 13 '05 #2

P: n/a
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.


Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.