Propriatpry Access Application and Network Access

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

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/edition...s/default.mspx


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


--

Regards,

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


"Tom" wrote:
> 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
>

"Tom" <(E-Mail Removed)> wrote:

>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/

"Dave Patrick" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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/edition...s/default.mspx
>
>
> http://support.microsoft.com/?kbid=296264
> http://support.microsoft.com/?kbid=300216#11
> http://support.novell.com/cgi-bin/se...?/10085899.htm
> http://support.novell.com/cgi-bin/se...?/10091561.htm
>
>
> --
>
> Regards,
>
> Dave Patrick ....Please no email replies - reply in newsgroup.
> Microsoft Certified Professional
> Microsoft MVP [Windows]
> http://www.microsoft.com/protect
>
>
> "Tom" wrote:
>> 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.

"Tony Toews [MVP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> "Tom" <(E-Mail Removed)> wrote:
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.