Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Propriatpry Access Application and Network Access

  
   Database Help (Home) -> MS Access RSS
Next:  Oracle, Solaris 8 and ensuring dynamic linking  
Author Message
Tom

External


Since: Oct 01, 2008
Posts: 5



(Msg. 1) Posted: Mon Oct 13, 2008 12:23 am
Post subject: Propriatpry Access Application and Network Access
Archived from groups: microsoft>public>access, others (more info?)
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

 >> Stay informed about: Propriatpry Access Application and Network Access 
Back to top
Login to vote
Dave Patrick

External


Since: Nov 11, 2006
Posts: 9



(Msg. 2) Posted: Mon Oct 13, 2008 7:11 am
Post subject: Re: Propriatpry Access Application and Network Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
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" 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
>

 >> Stay informed about: Propriatpry Access Application and Network Access 
Back to top
Login to vote
Tony Toews [MVP]

External


Since: Nov 15, 2007
Posts: 1139



(Msg. 3) Posted: Mon Oct 13, 2008 5:39 pm
Post subject: Re: Propriatpry Access Application and Network Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Tom" <whizzy DeleteThis @earthlink.com> 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/
 >> Stay informed about: Propriatpry Access Application and Network Access 
Back to top
Login to vote
Tom

External


Since: Oct 01, 2008
Posts: 5



(Msg. 4) Posted: Sat Oct 25, 2008 9:51 pm
Post subject: Re: Propriatpry Access Application and Network Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Dave Patrick" <DSPatrick.RemoveThis@nospam.gmail.com> wrote in message
news:OBhm4UTLJHA.5164@TK2MSFTNGP04.phx.gbl...
> 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" 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.
 >> Stay informed about: Propriatpry Access Application and Network Access 
Back to top
Login to vote
Tom

External


Since: Oct 01, 2008
Posts: 5



(Msg. 5) Posted: Sat Oct 25, 2008 9:52 pm
Post subject: Re: Propriatpry Access Application and Network Access [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Tony Toews [MVP]" <ttoews RemoveThis @telusplanet.net> wrote in message
news:qqm7f41m6adpsjm2fchna2r2j5chcjs3n2@4ax.com...
> "Tom" <whizzy RemoveThis @earthlink.com> 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.
 >> Stay informed about: Propriatpry Access Application and Network Access 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> MS Access All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]