.mde file copies

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • NewUser07
    New Member
    • Mar 2007
    • 3

    .mde file copies

    Hello everyone,

    I am quite new to this forum and also to Access.
    I have a quick question regarding splitting a database: do I need to create a .mde file for each front end copies? (installed on each user desktop on the server). The master FE and master BE are on the server.

    Please let me know if you need more infos fro this question.

    Thanks a lot.

    NewUser07
  • MMcCarthy
    Recognized Expert MVP
    • Aug 2006
    • 14387

    #2
    Multiple users can use the same frontend and you can create shortcuts to this frontend which they can place on their desktop.

    Comment

    • NeoPa
      Recognized Expert Moderator MVP
      • Oct 2006
      • 32633

      #3
      NB. You need to consider multi-user issues when either the FE or the BE database is used by more than a single user.

      Comment

      • NewUser07
        New Member
        • Mar 2007
        • 3

        #4
        Thank you Mmccarthy and NeoPa

        So do you mean that after creating the master FE .mde file, I should create a shortcut directly from each user's workstation. Do I need to save it on the same drive as the FE .mde file i.e on the server or on their local C:\drive?

        I am also concerned about a backup. Do we backup the master BE.mde file by just copying it on the server after work? we have Access 2k. Access 2002 and Access 2003.

        Thanks again for your help!

        NewUser07

        Comment

        • NeoPa
          Recognized Expert Moderator MVP
          • Oct 2006
          • 32633

          #5
          Originally posted by NewUser07
          So do you mean that after creating the master FE .mde file, I should create a shortcut directly from each user's workstation. Do I need to save it on the same drive as the FE .mde file i.e on the server or on their local C:\drive?
          Shortcuts are an option rather than a necessity. You can put them where they make it most convenient for your users.
          Originally posted by NewUser07
          I am also concerned about a backup. Do we backup the master BE.mde file by just copying it on the server after work? we have Access 2k. Access 2002 and Access 2003.
          Yes. Quite easy really :)

          Comment

          • NewUser07
            New Member
            • Mar 2007
            • 3

            #6
            Thanks very much for this help!

            NewUser07

            Comment

            • NeoPa
              Recognized Expert Moderator MVP
              • Oct 2006
              • 32633

              #7
              No problem - Glad to help :)

              Comment

              Working...