We help IT Professionals succeed at work.

fpdtc.dll

sco147
sco147 asked
on
Medium Priority
1,711 Views
Last Modified: 2012-05-06
We have recently installed Office 2007 in our office but left the Access users with Access XP.  Now they receive an error stating "Your Microsoft office Access database or project contains a missing or broken reference to the file 'fpdtc.dll' version 1.0. *To ensure that your database or proejct works properly, you must fix this refernece. "

Any ideas on how to repair this reference?  Repairing the app through the control panel did not work.
Comment
Watch Question

CERTIFIED EXPERT
Commented:
Backup your database.
The first thing to do is to open any module in design view; then choose Tools>References and see if you have a missing reference for this dll.
If so, uncheck it, close the dialog and then use Debug>Compile to make sure there are no errors.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
it may also be that you really need that reference.  After un-checking it, you might need to close the DB and Access and then re-check the reference so your code works.
It may be a case that in A2007, the reference is currently broken, but the code does need it.
JimD.

Author

Commented:
It's Access 2002 SP3.  I don't have a tools reference ability.  Sorry, outside my realm of expertise here....
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017
Commented:
<< I don't have a tools reference ability.  Sorry, outside my realm of expertise here....>>
  You won't see that until you open a module in design view as Peter mentioned.  That command is only available when your in VBA code editor.
  If this is in a MDE database though, you won't be able to do that.  You'll need to go back to the MDB, fix the reference, then create a new MDE if that's the case.
JimD.

Author

Commented:
opening the mdb in 2007, going to VB from the database tools, opening any one of the mudules and unchecking the reference appears to have worked.  The Access 2002 users are now able to work again.
We could not re-add this reference as the dll disappeard off the machines that upgraded the balance of their applciations (excel, work and powerpoint) to 2007
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
<<opening the mdb in 2007, going to VB from the database tools, opening any one of the mudules and unchecking the reference appears to have worked.>>
Kind of curious then why you did not award Peter with the answer...did you make a mistake?
JimD.

Author

Commented:
If you got it all I did.  The intent was to split it 300 and 200 in favour of Peter.  Apparently that didn't happen.
 
Jim Dettman (EE MVE)President / Owner
CERTIFIED EXPERT
Fellow
Most Valuable Expert 2017

Commented:
Well as it so happens, I am the page editor for the zone, so we'll just reopen this and you can take another swing at it!
JimD.
CERTIFIED EXPERT

Commented:
Thanks

Pete
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.