Members
  • Total Members: 12814
  • Latest: Rono
Stats
  • Total Posts: 28517
  • Total Topics: 8240
  • Online Today: 976
  • Online Ever: 51419
  • (01. January 2010., 10:27:49)












Author Topic: Access opens with the symbol  (Read 753 times)

0 Members and 1 Guest are viewing this topic.

reyes

  • SCF Newbie
  • *
  • Posts: 2
  • KARMA: 0
  • Gender: Male
Access opens with the symbol
« on: 12. July 2016., 12:41:33 »
We are getting this error when opening our Access 2007 database " Object 'MSysCompactError' already exists" and when it open all the boxes are filed with the symbol #
Does anyone know how we can fix this, we have tried restoring the file  from several days and the same is happening. I make sure everyone was out of the database when we restore it.

This is MS Access 2007 on Windows 7 computers.

Samker's Computer Forum - SCforum.info

Access opens with the symbol
« on: 12. July 2016., 12:41:33 »




Graversen

  • SCF Newbie
  • *
  • Posts: 2
  • KARMA: 0
  • Gender: Male
Re: Access opens with the symbol
« Reply #1 on: 19. July 2016., 16:25:08 »
Before doing anything else, make a copy of your database.

First make sure that your installation of Windows and Office is fully up to date.

Try importing everything to a new, blank database. To do that, create a new database, then use the External Data ribbon item, select Access, then select the trouble db and try to import everything to the new one.

If that doesn't work, you might try a compact operation, but if you can't open the database you may have troubles with that. You can compact from another database via code:

DBEngine.CompactDatabase "full path to the trouble db", "Full path to a different db"

Note the second db (the "full path to a different db") does not need to exist.

If that doesn't work, you might need to enlist the aid of a 3rd party to help. Access Recovery Toolbox at  http://www.oemailrecovery.com/access_recovery.html  does a very good job of recovering Access databases.

Graversen

  • SCF Newbie
  • *
  • Posts: 2
  • KARMA: 0
  • Gender: Male

reyes

  • SCF Newbie
  • *
  • Posts: 2
  • KARMA: 0
  • Gender: Male
Re: Access opens with the symbol
« Reply #3 on: 21. July 2016., 18:11:29 »
You've been very kind in your efforts to help. Thanks for that. Solved!

 

With Quick-Reply you can write a post when viewing a topic without loading a new page. You can still use bulletin board code and smileys as you would in a normal post.

Name: Email:
Verification:
Type the letters shown in the picture
Listen to the letters / Request another image
Type the letters shown in the picture:
Second Anti-Bot trap, type or simply copy-paste below (only the red letters):www.scforum.info:

Enter your email address to receive daily email with 'SCforum.info - Samker's Computer Forum' newest content:

Terms of Use | Privacy Policy | Advertising