Results 1 to 7 of 7
  1. #1
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    2 Updates requested. (A-2k)

    I have a client who has a database on a peer to peer network with 5 concurrent users.
    It's already split - FE and BE and is now an MDE file.

    Issue 1 :
    They are having problems with the system crashing alot with only 5 users.

    Can a 5 - user database run succesfully on a peer to peer network...at all <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>
    Would increasing the refresh rate interval help with the 'collisions'?

    Issue 2:
    How hard is it to install user-level security after it has been separated into front and back ends and saved to an MDE file?

    Since I basically work in A-97 at work and this will be an outside project, are there any special tools A2k has that will facillitate this move?

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

    Re: 2 Updates requested. (A-2k)

    5 concurrent users on a peer-to-peer network shouldn't be a problem. You might want to look at the PC on which the backend resides. It should have plenty of memory. And what do you mean by "system crashing"? Also, is backend an MDE? You might want to leave it an MDB.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 Updates requested. (A-2k)

    <hr>system crashing <hr>
    Apparently, it locks up on the users. Sorry I wasn't more descriptive with that.

    as to the MDE part..

    I believe that when you split the FE and BE and save it, the extension option is an MDE..
    This compiles the app...and hides all sourcecode and VBA script.

    <A target="_blank" HREF=http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/acconAboutMDEADEFiles.asp>http://msdn.microsoft.com/library/default....MDEADEFiles.asp</A>

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

    Re: 2 Updates requested. (A-2k)

    An MDE is a compiled version of a MDB file. You create it from within Access by selecting from the Main Menu bar: Tools | Database Utilities | Create MDE file. This doesn't convert your existing database, the MDB file stays intact; it creates another file (the MDE). Typically, one would keep the MDB file separate, and distribute the MDE file to users. No-one can modify a MDE file; that is Design View is not available. Because they are compiled, MDE files tend to run somewhat faster than an MDB. In the backend database, there is little need to compile, so it is usually best to keep it an MDB.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  5. #5
    4 Star Lounger
    Join Date
    May 2003
    Location
    Austin
    Posts
    401
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 2 Updates requested. (A-2k)

    Cool, Thanks for the clarification

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

    Re: 2 Updates requested. (A-2k)

    Some more clarification :
    In a MDE file you have no design for forms, report, pages, macro and modules.
    The design of tables and query's are not protected.[text, so the user can destroy data.
    To protect structure, use user security.
    A good start of user security :
    <A target="_blank" HREF=http://support.microsoft.com/support/access/content/secfaq.asp>http://support.microsoft.com/support/acces...tent/secfaq.asp</A>

    Francois
    Francois

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

    Re: 2 Updates requested. (A-2k)

    Mark is right - 5 users shouldn't be causing any performance problems as long as the "server" PC is solid - our clients run several DBs with more than 5 users with no problems. Another thing you might consider is to put the "Code" database on each user's PC and link to the "Back End" database which only contains tables - otherwise you are pulling complex forms, reports, etc across the network
    Wendell

Posting Permissions

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