MS Query, SQL Server 7 and Office 2001

G

Gavin Du-Haney

I cannot get MS Query to work correctly when using the SQL Server 7
driver supplied by Microsoft. I am only having the problem under OS
8.6 - It is fine with OS 9.2.
I am using MS Query v9 which came as part of the Office 2001 Value
Pack.
I am using the SQL Server 7 driver which came as part of the Data
Access Update for Office 2001.

The problem I am having is when I create a new query, I first select
my ODBC connection that uses the SQL Server 7 driver. Once selected, I
should be prompted for a username and pssword to connect to the SQL
database, but on OS 8.6, this username/password dialog box does not
display. The weird thing is though, that although the
username/password dialog box does not display I can still type the
username, press tab, type the password, press tab and then Enter and I
am take into the usual Query screen - so the dialog box is there, but
I just can't see it.

This is not a problem specific to just one machine - all of our
company's OS 8.6 machines have the same problem.

Can anyone out there help???
 

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