Help with an error message

[Paul Martin]

I have created a database on one PC at work during the day for use at home.
Now I have got the database on the home PC I get an error message as the
database opens. The error message is.....

The Models Database database or project contains a missing or broken
reference to the file SWBand.dll version 2.0.
*to ensure that your database or project works properly you must fix this
referenc

This concerns me because its not a link I have knowingly created, I don't
know how to find the link to fix it and I don't know how to fix it. I
suppose I could search for the dll on when back at work on Monday and copy
it to my penstick and install it here at home but I can't do that until
Monday and it sounds a bit "iffy"

I would be grateful if someone could explain more of whats going on here and
suggest a fix without resorting to copying files from the other machine

Thanks

Paul Martin

 

[George Nicholson]

In the VB editor, under Tools>References there is a list of References
"attached" to the mdb file. One of those is the dll in question and it will
appear in the list as "MISSING". That's what triggered the error.

If you designed the db and you don't know what the reference is for, there
is a good chance you don't need it. Extraneous references aren't uncommon
and i'm fairly confident that this is an extremely non-standard file (google
provides no hits...) that you would know about if you were actually using it
in your app. You can try unchecking the reference (if it lets you), compile,
and try running the app without the reference (backup first, but I don't
think you can do any harm trying this). If lucky, it'll run fine (but
remember to uncheck the reference on the office version). At worse, you'll
end up exactly where you are now: needing to install the missing file on
your home PC in order to make the app work.

There is also a chance that your home PC may have a different version of the
dll available. If so, you can try and find it in the reference list,
checking that version, compile, and see what happens.

HTH,

 

[Albert D. Kallal]

That file is likely some type of licensing key or system that the vendor
provides with he apcpation.

I would contact the developer of the application, and enquiry as to this
issue.

It also just simply a dll' that the application needs to run, and you don't
have this dll installed correctly on your machine. You likely have to
install some other package, or software to resolve this issue.

It could also simply be a broken reference, and you don't actually need that
dll file to function.

Is a mdb (or mde) that you built and designed, or someone else's?

Anyway,

You can read about fixing broken references here:

Allen Browne
http://allenbrowne.com/ser-38.html

Doug Steele:
http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

Peter Walker:
http://www.papwalker.com/dllhell/index-page2.html

 

[Paul Martin]

Its a an MDB that I built at home initially. I have used it with no frills
[=big list] for a couple of years. I have been having a quiet week at work
this week so I have been using the time to add some frills like forms and
queries. Tonight i brought it home and have tried it on 2 PC's, one with XP
and one with Vista, and got the message reported on both machines.

If i ignore the error message it all seems to work. Its not something i have
either deliberately or knowingly done

 

[Albert D. Kallal]

ok, then, it is likely a broken reference...

While in code, check the tools->references..and look for a "missing one"....

Try upchucking that missing one...you don't need it....