Results 1 to 3 of 3
  1. #1
    dwaterman is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Location
    Elkhart, IN
    Posts
    22

    Trouble converting MDB database to Accdb - Says the database is already open when I save.

    I created a database several years ago in the 2003 version of Access. I believe everyone in our office is now converted to at least a 2010 version and I am trying to convert this database to the accdb format. I found instructions on how to do this by saving in the new format. When I tried converting in the 2010 version, it did not give me the option to save in the accdb format. I am now trying it in a 2007 version of Access, but I get a message saying the database is already open exclusively by another user when I save. I am the only one in the database, as I am working in a copy at home. I'm not sure where to go from here. Any help is appreciated.

  2. #2
    dwaterman is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Location
    Elkhart, IN
    Posts
    22
    I just figured it out from another post. For anyone having the same problem, I had to delete my AutoExec file that opened to the switchboard, close the database and reopen it. Once that was done, I was able to save in the accdb format, the re-create my AutoExec file.

  3. #3
    ssanfu is offline Master of Nothing
    Windows XP Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Thanks for posting the solution! I'm sure it will help someone in the future.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. DAO issue after converting to .accdb
    By clancy76 in forum Access
    Replies: 3
    Last Post: 04-23-2015, 03:33 PM
  2. Unrecognized database format 'C:\xx.accdb'
    By jjotc23 in forum Access
    Replies: 4
    Last Post: 05-06-2013, 03:58 PM
  3. How do I make my .accdb database 'Read Only'
    By TongaJim in forum Database Design
    Replies: 9
    Last Post: 02-09-2013, 06:18 PM
  4. Replies: 5
    Last Post: 11-06-2012, 05:05 AM
  5. converting mdb to accdb format
    By crowegreg in forum Access
    Replies: 1
    Last Post: 05-31-2011, 10:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums