Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

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.
0
sco147
Asked:
sco147
  • 4
  • 3
  • 2
2 Solutions
 
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)PresidentCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
Jim Dettman (Microsoft MVP/ EE MVE)PresidentCommented:
<< 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)PresidentCommented:
<<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)PresidentCommented:
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

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

  • 4
  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now