Querying MS SQL database

R

Randy

Hello, I'm not sure if I have the right forum, but here is my dilemma: Using
Access 97, I have configured an ODBC DSN to connect to a SQL database on our
network and populate records in the local Access database. These records are
populated as jobs are running on the SQL server. Some records are missing
from the populated database, and despite upgrading the ODBC driver, upgrading
to Jet 4.0 SP8, uninstalling and reinstalling Access 97, and trying TCP
(dynamic port addressing) and then Named Pipes, I cannot get those records
to appear. This only seems to be happening on new PCs we have recently
deployed in our environment (HP P4 2.8GHz desktop PCs). Any ideas? Very much
appreciate it. Thanks.

Regards,

Randy
 

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