Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Access runs slow over network, but only on my PC 1

Status
Not open for further replies.

BFP

Technical User
May 18, 2000
52
US
I realize this problem may be out there, but I am desperate at this point.<br><br>I created an Access 2000 database, which runs fine on my computer, but when I load the DB to a shared network drive, it takes several minutes for the DB to load.&nbsp;&nbsp;Now, this might not seem so strange, EXCEPT it runs without a noticeable slowdown on my co-workers PC's, which are virtually identical to mine.&nbsp;&nbsp;Well, after looking into this problem for the past few days, I have compiled the following list of facts:<br><br>* I have two versions of NT installed (SP 6 and 6a).&nbsp;&nbsp;SP6 is virgin and only has Access and a few other programs installed.&nbsp;&nbsp;My DB runs just fine on the &quot;clean&quot; NT install.<br><br>* I had compared various drivers and found my ODBC drivers under the &quot;non-clean&quot; NT install&nbsp;&nbsp;were slightly newer than the clean NT and my co-workers had the older ODBC drivers as well.&nbsp;&nbsp;I did try to load all but a couple of the old ones without success.<br><br>* Again, the setup of my PC is virtually identical to that of my co-workers: same network adaptor, CPU, memory, etc, and the programs etc are also virtually identical.<br><br>There are some other things that I consider less minor that I have looked into as well, so if there are any other information I can provide, let me know because I am at my wits end and no closer to a solution.<br><br>Thanks and Regards,<br><br>--Dan
 
&nbsp;&nbsp;&nbsp;&nbsp;Are you sure it's the same network adapter?&nbsp;&nbsp;Maybe it's it's only 10mbs instead of a 10/100mbs controller?&nbsp;&nbsp;I would check to make sure that's not the problem if you haven't, other than that I can't think of much.&nbsp;&nbsp;You seem to have covered most of the basics.&nbsp;&nbsp;If you can't get help here, try a networking forum.&nbsp;&nbsp;Sounds like it might be a network config problem on your machine, or hardware, rather than an Access problem. <p>xtreme1<br><a href=mailto:rbio@excite.com>rbio@excite.com</a><br><a href= > </a><br>
 
Yes I am sure it is the same 10/100 mbs fast ethernet controller.&nbsp;&nbsp;This and some other checks make me almost positive it is not a network problem.&nbsp;&nbsp;Recall that I have another version of NT installed and in this &quot;clean&quot; version, Access works without a hitch.<br><br>Also, I forgot to mention a few things:<br>* There seems to be no HDD or CPU activity after 5-10 seconds and then, after a few minutes, the form within my DB finally just appears.<br><br>* I did install some updates from Microsoft for things like better virus protection for my email, etc.&nbsp;&nbsp;One thing was Service Pack 1a for Office 2000 Premium.&nbsp;&nbsp;I did not install this patch on my clean version of NT.<br><br>I am still hoping there is a clue here somewhere.&nbsp;&nbsp;I was almost sure it was the new ODBC drivers, but have not been able to prove it yet.<br><br>Any ideas?<br><br>Regards,<br><br>--Dan<br><br>
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top