Query of Existing Tables, Queries , or Both

C

Crockett

I have a user (developer), Windows 2000 with Office XP, that does most of his
work in Access. When he tries to create a new query in an existing database
using the design view and if the number of existing tables, or queries, or
those listed under both exceed the amount that will fit in the window before
the scroll bar appears, the window displays either a couple of the existing
entries or is blank. We have played with this to the point that if 13
entries are listed under the tables tab, query tab, or both tab, everything
is fine. But if we create say a 14th table and then try to do a new query in
the design view, the tables tab is all screwed up but the query tab and both
tab are fine. Likewise, if we have 14 queries to display or the number of
items under the both tab is more than 13, they will be screwed up. My
apologies if I am not being clear but it is hard to explain. We have tried
this with several different databases and it is consistent. I have tried
doing a Detect and Repair as well as uninstalling and reinstalling the entire
Office XP suite but neither of those helped. I think that this may be a
problem with Windows 2000. Any help or suggestions would be greatly
appreciated.
 
J

Jerry Whittle

That is strange, but I don't think that it's an Access problem. Does the same
behavior happen when the database is on another computer? Has any other
strange things happened on that computer?

I'd start by checking the display settings for the computer. Make the
Appearance standard Windows Classic with normal fonts and colors. Possibly
reduce the number of colors or in the Advanced tab and troubleshoot by using
less Hardware Acceleration.

You might also check for the latest video drivers for the computer.
 
C

Crockett

Well, I've tried everything that you've suggested and the problem still
persists. I'm going to try a Windows 2K repair process.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top