interacting with 2003 database while using Access 2007

[Greg]

Another organization generates a database in Access 2003 that I have to
interact with and send back. I am using Access 2007. The error message that
I get is to the effect that the database or project contains a missing or
broken reference to the file FPDTC.DLL version 1.0.

Any ideas?

 

[banem2]

Another organization generates a database in Access 2003 that I have to
interact with and send back.  I am using Access 2007.  The error message that
I get is to the effect that the database or project contains a missing or
broken reference to the file FPDTC.DLL version 1.0.

Any ideas?

Coder of Access 2003 database has used FPDTC.DLL as reference in VBA.
You need to ask them to send you that file. When you got it, save it
somewhere and go to VBA screen (CTRL+G) and update reference in Tools
\References.

Regards,
Branislav Mihaljev, Microsoft Access MVP

 

[Evi]

That DLL has something to do with Microsoft Front Page Design-Time from
Office 2003.
Full name - Microsoft Office FrontPage Design-Time Controls, 11.0.6361

Check if you have the dll on your PC. If not, you will need to get a copy
from a machine with 2003 on it and register it on your PC. I'm not sure how
to do this on later versions on Windows but I just double click on the file
and browse to Regsvr32 in the Open With box (leaving the Always Open With
box unticked)

If you are very lucky, open any Module, go to Tools, References. See if the
word Missing is next to any of them. If it is, write down the name, untick
the box.
See if your db works now by re-opening the module and going to Tools, Debug.
If anything barfs, go back to References, find the name which had missing
next to it and tick it.

If that doesn't work, look down the list of references for its Full Name.
If you find it, tick it. Debug again.


Evi

 

[Rick Brandt]

That DLL has something to do with Microsoft Front Page Design-Time
from Office 2003.
Full name - Microsoft Office FrontPage Design-Time Controls, 11.0.6361

Check if you have the dll on your PC. If not, you will need to get a
copy from a machine with 2003 on it and register it on your PC.

I should point out here that the OP might not have legal rights to copy this
DLL to any other PC.

Better would be to first see if the app runs correctly with that reference
eliminated altogether. It is not unusual for an app to acquire the odd
reference addition over time, but often the reference is not actually
required and can be safely eliminated.