MS Access Multiuser - Network performance

Author

Network performance

orjan hagstrom

2006-01-31, 7:24 am

Hi

I have an 2000Access application which run in several network
installations.

One of my customers claims that the application is very slow in his network.

On the server he has the table database (containing all his recorded data)
and the .mdw-file. On the client he has the object database (containing
forms, reports, code etc) and the Access 2000 runtime.

The path to the table database is very long with blanks and dots as you can
see below

G:\Kulturverksamhet\
Konstmuseum\Offkonst
\Konstregister backup
4. 11\Konstverksbilder\
ktables.mdb

I have two questions if someone can help me on this:

Does a long path slow down the performance?

Is Runtime slower than the "real" Access?

Best regards

Joan Wild

2006-02-01, 9:27 am

orjan hagstrom wrote:
>
> I have two questions if someone can help me on this:
>
> Does a long path slow down the performance?

Yes it can.

>
> Is Runtime slower than the "real" Access?

Not to my knowledge.

Have a look at the following page for some pointers on performance:

http://www.granite.ab.ca/access/performancefaq.htm

--
Joan Wild
Microsoft Access MVP

Tony Toews

2006-02-02, 3:25 am

"orjan hagstrom" <orjan.hagstrom@spray.se> wrote:

>Is Runtime slower than the "real" Access?

No. It's the exact same msaccess.exe with registry settings making it
a runtime.

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

Sponsored Links