fpdtc.dll

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.
sco147Asked:
Who is Participating?
 
peter57rCommented:
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.
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
 
sco147Author Commented:
It's Access 2002 SP3.  I don't have a tools reference ability.  Sorry, outside my realm of expertise here....
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<< 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.
0
 
sco147Author 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
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
<<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.
0
 
sco147Author 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.
 
0
 
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
 
peter57rCommented:
Thanks

Pete
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.

All Courses

From novice to tech pro — start learning today.