Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 884
  • Last Modified:

MS Access error

Usr getting error msg:
Your Microsoft Access Database or project contain a missingg or broken reference to the title 'msstdfmt.dll' on opening Access Database.  Any ideas how to fix?
0
losgadas
Asked:
losgadas
2 Solutions
 
Jerry MillerCommented:
You need to go into the VBA menu in Access.

From http://support.microsoft.com/kb/283806:

To remove the missing reference, follow these steps:
1.Open your database.
2.Press ALT+F11 to open the Visual Basic Editor.
3.On the Tools menu, click References.
4.Click to clear the check box for the type library or object library marked as MISSING: <referencename>.

An alternative to removing the reference is to restore the referenced file to the path that is specified in the References dialog box. If the referenced file is in a new location, clear the MISSING: <referencename> reference, and then create a new reference to the file in the new folder.

NOTE: In an Access run-time application, you cannot view references from a menu. However, the following article demonstrates how to view references using code:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
That's the Microsoft Standard Data Formatting Object Library.

If your database requires that reference, then removing it won't help, since that will only trigger another error.

To determine if you need the reference, do this:

1. Make a backup of your database
2. Open the VBA Editor window and click Debug - Compile. Fix any errors, and keep doing this until the Compile menuitem is disabled
3. Now click Tools - References, locate the suspect reference and uncheck it. Be sure to note the full path to the reference, and then close the References dialog.
4. Now Compile again.

If the second Compile does not produce errors then you don't need the reference.

If the second compile does produce errors, and those errors reference areas where your code uses the reference, then you'll have to resolve this. In most cases, I would first try a repair install of Office. If that doesn't work, then an uninstall/reinstall would be next.

Also be sure that your Windows and Office installations are fully up to date.
0
 
losgadasAuthor Commented:
thank you so much!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now