Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access & P-P Networks (A2K)

    I have set up a small offie network using the XP Networking and Ethernet hubs (also has a DSL Router). I have Access front ends on all of the computers with one computer acting as the 'host'. I then link to the data database on the host computer. Basically I am flying blind. It works but much of the time, it is very slow. There are only about 5 computers on the system now though will grow to 10 shortly. My questions:

    1. Is there a better way of doing this on a Peer to Peer network with Access?

    2. Any recommdendations on reference materials to understand what is going on behind the scenes?

    3. How can I tweak it or what should I even look for to get the performance up?

    I realize that these are rather general questions. However the client can't afford a WIndows server or SQL server at the moment.

    Thanks in advance,

    Alan

  2. #2
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access & P-P Networks (A2K)

    Alan,
    Not sure if it's a prerequisite for XP Networking, but Windows XP seems to handle connecting to a back end better than Windows 2000 (at least for me). Also ensure your back end isn't hidden deep within a million (exaggerating) folders, you're better off with the back end 1 folder deep into a drive, and assigning permissions accordingly. Having to connect through too many folders can also slow down your connection....

    My <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>, from many a <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15> night. <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What&#39;s more, you deserve to be hacked." -Richard Clarke

  3. #3
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access & P-P Networks (A2K)

    The folder is right below c:. Its a shared folder so all the other computers can see it okay. Slow opening forms/tables/reports. Are there any other permissions that I should set and where? Would going thru hubs significantly degrade the speed?

    Thanks for reponse.

    Alan

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Access & P-P Networks (A2K)

    With that kind of configuration, it doesn't seem that you should be seeing performance problems - my suspicion off the top of my head is that you need to add indexes to the tables to make sure you are getting good performance on queries and subforms and the like. Bear in mind that Access is not a database engine, and that unless you specify otherwise, it has to pull all of the indexes and any data from any tables in a query over to your workstation before it can do anything else. So unless your 5 users are doing heads down data entry, it should be possible to get reasonable performance.

    With that in mind, here are some things to think about:
    - Is the LAN a 100Mbit Lan?
    - Are you trying to return large sets of data, or only a few records at a time - the fewer the better?
    - How much RAM does each workstation have - more is better?
    - Does the system chosen as the server also have other traffic on it - dedicated would be better?
    - Do your form designs lead to good performance - continuous forms which display lots of records can be problems?
    - Are you using combo boxes, list boxes and subforms judiciously?
    - Finally, do most fields where you are likely to be selecting records based on joins or criteria have indexes on them?

    Performance is an interesting topic, and not one that has lots of pat answers, but we'll be happy to try to help you tune your system.
    Wendell

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Access & P-P Networks (A2K)

    I agree with Wendell, there shouldn't be any reason to expect performance problems with the network you described.

    One thing to check is how the performance is with just one workstation at a time in the database. You might also want to check for other network activity. And what about that computer that is the "host"? How big, how fast, how much memory? In Control Panel, there is a System selection, and on that there is an Advanced tab. Check the Performance settings, allocating more memory to background services on your "host".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Access & P-P Networks (A2K)

    Could AutoCorrect be a problem?

  7. #7
    Star Lounger
    Join Date
    Apr 2001
    Location
    Naperville, Illinois, USA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access & P-P Networks (A2K)

    Thanks for all the suggestions. I will reset the System settings on the 'host' and check all of the indexes on the tables. I generally have a Primary Key on all tables. Looking at a couple of tables (a copy off site, it does appear that on some of the tables there are too many indexes). The host computer is new with 2 gig memory and a fast processor (Intel). I didn't really look at the main hub that was there, so I will tomorrow. It is a combo Wireless / Wired Microsoft hub. The other hubs are new and shouldn't be a problem. Would one slow workstation slow down all the others? How can I check the traffic speed on the LAN or do I need special equipment? Boy, do I appreciate this forum!

    Alan

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access & P-P Networks (A2K)

    You can also have a look at Microsoft Access Performance FAQ.
    Especially look at Sub Datasheet Name property set to [Auto]
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •