Problem with shared access program

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Randoz
    New Member
    • May 2007
    • 27
    #1

    Problem with shared access program

    I have a shared access program is a shared directory on a server. I have put no restictions are set up anything different than the defaults. Some indivduals are not having any problem at all and love the input/output of the data. However, some indivduals click on the location and the file comes to their desktop as a 'read-only' file. Another indivdual will click on an item in the switchboard and they will do a back up of the database. Does anyone have an ideal why this is happening? It works great for about 90% of the individuals. Please help.

    Randy
    Tags: None
    • Rabbit
      Recognized Expert MVP
      • Jan 2007
      • 12517
      #2
      For the read-only problem I would check the user's permissions on active directory or workgroup, whichever you use.

      For the backup problem... I'm confused. Are you saying that no matter what button they click on the switchboard, it makes a backup of the database?

        Comment

        • missinglinq
          Recognized Expert Specialist
          • Nov 2006
          • 3533
          #3
          Multiple-users with an Access app on a shared directory is, according to many, one of the leading causes of corruption, which may explain the strange Case of the Unwanted Backup!

          Linq ;0)>

            Comment

            • tdw
              New Member
              • Mar 2007
              • 206
              #4
              Originally posted by missinglinq
              Multiple-users with an Access app on a shared directory is, according to many, one of the leading causes of corruption, which may explain the strange Case of the Unwanted Backup!

              Linq ;0)>
              Agreed. That was exactly why our VERY important orders database corrupted itself a few times, which caused us major headaches.

              Finally, when I took over maintaining it, and decided to beef it up, One of the first things I did was to split it into a Front-End/Back-End database. That seems to have fixed that problem, and it runs much faster on user's computers.

                Comment

                • MMcCarthy
                  Recognized Expert MVP
                  • Aug 2006
                  • 14387
                  #5
                  I agree with missinglinq and tdw. Splitting the db to a frontend/backend is a good idea. And creating separate frontends for each user will make it even more efficient.

                  However, to direct back to your original question I think the issue is related to the fact that setting the database to shared is application specific. So if all your users have their own access application on their desktop you will need to check the settings in Tools - Options - Advanced and make sure they are all set to shared.

                  I do recommend though that you go with tdw and missinglinqs suggestion.

                    Comment

                    Previous template Next
                    Working...