Propriatpry Access Application and Network Access

T

Tom

We have Proprietary application that created using Access97. It runs on a
P2P nine node network using W2K Pro and XP Pro PCs. Access times are very
good for the nine concurrent users. We'd like to move it to the main network
(MS Server 2003, one GB fiber back bone, 100BT to the PCs.) we heard from
another facility that the application runs slow on the Novell TCP/IP network
w/ thirty concurrent users. Is there any reason why the Access97
application would run slowly on a MS Server 2003 network: MS Server 2003,
one GB fiber back bone, 100BT to the PC w/ 20 concurrent users?
Thanks,

Jack
 
D

Dave Patrick

Make sure oplocks is configured appropriately if you can't upgrade.
Upgrading the backend to SQL Server or at least SQL Server 2005 Express is
the best solution.
http://www.microsoft.com/sql/editions/express/default.mspx


http://support.microsoft.com/?kbid=296264
http://support.microsoft.com/?kbid=300216#11
http://support.novell.com/cgi-bin/search/searchtid.cgi?/10085899.htm
http://support.novell.com/cgi-bin/search/searchtid.cgi?/10091561.htm


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect
 
T

Tony Toews [MVP]

Tom said:
We have Proprietary application that created using Access97. It runs on a
P2P nine node network using W2K Pro and XP Pro PCs. Access times are very
good for the nine concurrent users. We'd like to move it to the main network
(MS Server 2003, one GB fiber back bone, 100BT to the PCs.) we heard from
another facility that the application runs slow on the Novell TCP/IP network
w/ thirty concurrent users.

Is there a WAN involved on that other network? Multiple buildings
located a distance apart? If so that is likely the performance issue.
Although there is one reliable report of a 100 Mb WAN working well.
Is there any reason why the Access97
application would run slowly on a MS Server 2003 network: MS Server 2003,
one GB fiber back bone, 100BT to the PC w/ 20 concurrent users?

Have you tested this out yet?

Also see the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
T

Tom

Dave Patrick said:
Make sure oplocks is configured appropriately if you can't upgrade.
Upgrading the backend to SQL Server or at least SQL Server 2005 Express is
the best solution.
http://www.microsoft.com/sql/editions/express/default.mspx


http://support.microsoft.com/?kbid=296264
http://support.microsoft.com/?kbid=300216#11
http://support.novell.com/cgi-bin/search/searchtid.cgi?/10085899.htm
http://support.novell.com/cgi-bin/search/searchtid.cgi?/10091561.htm


--

Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect


Tom said:
We have Proprietary application that created using Access97. It runs on
a P2P nine node network using W2K Pro and XP Pro PCs. Access times are
very good for the nine concurrent users. We'd like to move it to the main
network (MS Server 2003, one GB fiber back bone, 100BT to the PCs.) we
heard from another facility that the application runs slow on the Novell
TCP/IP network w/ thirty concurrent users. Is there any reason why the
Access97 application would run slowly on a MS Server 2003 network: MS
Server 2003, one GB fiber back bone, 100BT to the PC w/ 20 concurrent
users?

Thanks, I'll check it out.
 
T

Tom

Tony Toews said:
to the PC w/ 20 concurrent users?
Have you tested this out yet?

No, not yet.
Also see the Access Performance FAQ page at
http://www.granite.ab.ca/access/performancefaq.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

Thanks, I'll check it out.
 

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