Weird bug on front end database

[cbende2]

Hey guys,

So I'm currently developing a database for a company and I've learned so much from this websites and other alike.

A little problem I'm having that is rather strange is that after updating the front end and sending it out to all the employees, some employees are getting errors stating that the reference library is missing MSOUTl.OLB version 9.5. After doing some research I found that it has to do with the references in VBA. I don't have much VBA code at all in the database, just a few commands here and there to automatically fill in the date OnClick. After checking the reference library, SOME users are Missing the Microsoft outlook 15.0 Object Library, and SOME aren't.



I'm guessing since only some of the machines are returning the error, that it is simply a machine related error, and not the actual database itself? Would this be a correct assumption?

Possibly users using different versions of outlook? Which is definitely a plausible reason, because we have about 20+ employees, and we update 5 computers a year, kind of like a rotation. Same goes for Microsoft Office, whoever is getting the new computer gets the new MSOffice.

[June7]

Outlook version incompatibility seems reasonable, in which case not so weird. Did you verify the version each user has?

[trevor40]

this happens when you create the db on your machine. it will be set to use various resources available on your machine depending on the version of the programs use have on your machine. when you transfer the db to another pc it may or may not have the same resources listed in the vba list, this can be an incorrect version or just missing. you need to update each copy of the db for each individual pc to use the resources available. i think that there is some vba code people have created to automatically update the reference list, i think that is what you will need.

[cbende2]

Thanks for the responses guys, its weird though, because I've been sending out front end copies for about 6-7 months now, and I'm only starting to come accross this problem now.

[cbende2]

Question, If none of my code involves using anything from Outlook, can i simply uncheck the outlook library?

[June7]

Yes. That should eliminate the issue. So why was it ever selected to begin with?

[cbende2]

Yeah it's working now, and I'm not sure why it was checked to be honest

[cbende2]

Thanks for marking my thread June, I would have thought that having that as my signature would help me remember