Networking Access

[Ric]

I have heard Access is slow on networks and am totally new
to networks and intranets. Are there any
recommendations? We will have two or three PC's to
connect. Thank You in advance for any advice I may
receive.

Ric

 

[Allen Browne]

Rumours, eh?

Access works *very* well on a LAN (local area network), providing the
network is stable.

A basic Access database barely works at all on a WAN (wide area network).

 

[Tony Toews]

I have heard Access is slow on networks and am totally new
to networks and intranets. Are there any
recommendations? We will have two or three PC's to
connect.

To add to Allen's comments a client has 15-25 users in all day long in
an Access MDB.

Part of the problem may be some bugs or features within Access. The
three most common performance problems in Access 2000 are:
- LDB locking which a persistent recordset connection or an always
open bound form corrects (multiple users)
- sub datasheet Name property set to [Auto] should be [None]
- Track name AutoCorrect should be off

If the problem is for everyone when starting up the MDB then it likely
needs a decompile.

For more information on these, less likely causes, other tips and
links to MS KB articles visit my 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