Post reply

Capacity for Access Project

  • April 28, 2009 at 5:07 am

    #984965

    I would never have more than one user per front-end, whether it be with linked tables, or as a project file. You get much better performance with each user having their own copy

  • April 28, 2009 at 4:32 pm

    #985564

    Hi,

    Thanks for your reply. If I was to have more than one user per front end, would using Access Project have more capacity (and if so, how much more)?

    Thanks

  • April 29, 2009 at 1:37 am

    #985678

    As you have noted, many users per front end leads to bloat and corruption.

    Don't do it.

    One user per front end also leads to bloat and corruption - it's a fact of life with Access. Even with compact and repair running a reasonable front end will eventually fall over.

    We've been running Access front ends since 1993, first with an Access back end and then as the system growed a SQL backend. The one fact of life with Access is corruption.

    We give every user a fresh front end every day. It's the only way we;ve found to keep the system running.

  • April 29, 2009 at 1:57 am

    #985682

    We have an Access front end to a SQL back end (adp, not linked tables) and each user has their own copy of the front end, which only gets refreshed when an update is sent out, and I can't remember the last time we had any front end corruption - there are approximately 50 users, 15 who update, the rest are view only

  • April 29, 2009 at 2:02 am

    #985683

    Thankyou very much. I appreciate your comments.

Viewing 5 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply