contains a missing or broken reference to the file ‘BFAddin.mda.’

[dcummins]

Our database is saved on a shared server and it's been working fine for
several years. Just last week, 2 of the 3 users of the database can not open
a couple forms. The problem was a text box with =format(date()). I changed
the way the date is pulled in--added a field to the source query--but now
we're getting the following: Your Microsoft Office Access database or
project contains a missing or broken reference to the file ‘BFAddin.mda.' To
ensure that your database or project works properly, you must fix this
reference.

I've tried updating software, but that didn't help. Any ideas? Thanks.

 

[John W. Vinson]

Our database is saved on a shared server and it's been working fine for
several years. Just last week, 2 of the 3 users of the database can not open
a couple forms. The problem was a text box with =format(date()). I changed
the way the date is pulled in--added a field to the source query--but now
we're getting the following: Your Microsoft Office Access database or
project contains a missing or broken reference to the file ‘BFAddin.mda.' To
ensure that your database or project works properly, you must fix this
reference.

I've tried updating software, but that didn't help. Any ideas? Thanks.

That sounds like a custom, specific library database (.mda) containing some
sort of addins. Do you have a file of that name on one of the computers where
this DOES work? If so, can you make the .mda file available to the other
computers, either as a copy or over the network?

It's possible that this was used at one point and now isn't: try making a COPY
of the database, unchecking the reference, compiling the project (Debug...
Compile on the VBA menu) and testing it. If it still works (and do test all
the forms and reports!) just leave it unchecked.

 

[dcummins]

I did have an addin for a barcode software program I had added to my
computer. I removed that addin from Access but it didn't take care of the
problem.

You said to uncheck the reference...I don't know what you're referring to.
Can you push me in the right direction?

Thanks for your help!

 

[Douglas J. Steele]

Go into the VB Editor and looks for Tools | References on the menu. There
will be a number of items checked at the very top of the list. One (or more)
of those will have MISSING: in front of them. Uncheck it (them).

 

[John W. Vinson]

I did have an addin for a barcode software program I had added to my
computer. I removed that addin from Access but it didn't take care of the
problem.

You said to uncheck the reference...I don't know what you're referring to.
Can you push me in the right direction?

Open the VBA editor (type Ctrl-G is one way). On the menu select Tools...
References. Find the reference for BFAddin; it will have a checkbox next to it
and may or may not be marked MISSING. If you don't need it for reading
barcodes simply uncheck it. Close the References window, select Debug...
Compile; if there are no error messages, close the VBA window and select
Tools... Database Utilities... Compact and Repair. This should put you back in
business!