(Database) already opened exclusively by another user...

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • stonward
    New Member
    • Jun 2007
    • 145
    #1

    (Database) already opened exclusively by another user...

    Hi Folks,

    This one is from work!

    Running Access 07, usually our default saving format is 2003 - not our fault.
    I want to publish a database to our SharePoint system, but the database must be in an 07 format, and I can't save new databases without getting the (above) message. I have tried taking permission of the file, creating a new database and transferring the data across and changing the default format. Nothing works. Once I have made (even a very simple) database, I can't 'Save As', and if I close it and attempt to re-open it I get the (above) message. Here it is in full:

    The Microsoft Access database engine cannot open the file <name>. It is already opened exclusively by another user, (no, it isn't!), or you need permission to view its data. (Error 3051).

    Any ideas?

    Thanx

    StonwardR
    Tags: None
    • DonRayner
      Recognized Expert Contributor
      • Sep 2008
      • 489
      #2
      Do you have the appropiate permissions to publish the database to your share point?

        Comment

        • stonward
          New Member
          • Jun 2007
          • 145
          #3
          Originally posted by DonRayner
          Do you have the appropiate permissions to publish the database to your share point?
          Thanx for your reply.

          Yeah, I've got permission to publish to SharePoint - I'm one of the SharePoint admins. Also, if i build a database at home, then bring it here to work, I can publish it! So it appears to be something to do with our Access set up here...

          StonwardR

            Comment

            • DonRayner
              Recognized Expert Contributor
              • Sep 2008
              • 489
              #4
              Originally posted by stonward
              Thanx for your reply.

              Yeah, I've got permission to publish to SharePoint - I'm one of the SharePoint admins. Also, if i build a database at home, then bring it here to work, I can publish it! So it appears to be something to do with our Access set up here...

              StonwardR
              Just throwing some ideas at ya. Could it be someting with your workgroup setup. You could try creating another workgroup and joining that

                Comment

                • xsquare
                  New Member
                  • Jun 2010
                  • 1
                  #5
                  I run into this issue too

                  I have access 2007 on my personal computer and i am having this issue. please help.

                    Comment

                    • Stressed Eric
                      #6
                      If you have the Switchboard running when the db starts, that causes a problem. Disable the Switchboard on Startup, convert the database, re-enable Switchboard. Voila!

                        Comment

                        Previous template Next
                        Working...