By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,401 Members | 928 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,401 IT Pros & Developers. It's quick & easy.

Access 97 Application Sloooooow performance

P: 2
Hi there,

We have an Access 97 application (client install on workstation PCs) that used to have it's Database backend hosted on a NetWare server. No real problems but it was decided to move it to a Windows based server. we have tried a Windows 2003 server and a Virtual Server and have found performance to be severley impacted on the client PCs. Cannot quite understand why. The clients are Windows 2000 SP4 or Windows XP SP2 with Novell Client 4.91 SP2 and probably Office 2000 or 2003 installed.

Anyone have any ideas?

Cheers

Keith
Sep 4 '07 #1
Share this Question
Share on Google+
4 Replies


Denburt
Expert 100+
P: 1,356
Hmmm, well first have you compacted both front and back ends? Second question is this running across a LAN or WAN?
Sep 10 '07 #2

Denburt
Expert 100+
P: 1,356
A couple more things just hit me. Are the links from the clients machine to the backend utilizing a mapped drive or direct path? Mapped is somewhat quicker, Microsoft also recommends using short file names when linked to a backend.
Sep 10 '07 #3

P: 2
A couple more things just hit me. Are the links from the clients machine to the backend utilizing a mapped drive or direct path? Mapped is somewhat quicker, Microsoft also recommends using short file names when linked to a backend.
Thanks Denbert, will check that out. I think it is mapped drives. The application is unfortunately compiled so we can't determine if the Db is split or not. I think that the naming is short filenames but againwill check. Also, it is running across a LAN (100MB to the desktop 1GB core).
Sep 11 '07 #4

Denburt
Expert 100+
P: 1,356
Well there is so much more that can be added but I think it's best if you look this over then let me know what you think or if you have more questions/issues.

http://support.microsoft.com/kb/889588
Sep 11 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.