Excel MSACC.OLB missing reference

[Nikkidoshi]

Hi,

I have a missing reference in my project on one of the computers. The file MSACC.OLB is not showing up on the C Drive.

Can I just copy and paste the file from my computer to the other computer? Will this fix the error?

Thanks,
Nikki

 

[Andrew Poulsom]

Is Access installed on that computer?

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

 

[Nikkidoshi]

No Access is not installed on that computer. I have built a tool in excel which is pulling data from an access database. It works for other computers even without access being installed.

 

[Andrew Poulsom]

I don't think it's legal to copy MSACC.OLB to another computer:

http://www.mofeel.net/171-microsoft-public-office-developer-vba/1561.aspx

 

[Nikkidoshi]

Okay. I was not aware of that. Is there a work around for this. Basically I am looking for data from an excel sheet to be updated to my access database directly.

 

[Andrew Poulsom]

How is it working on the other computers if Access isn't installed?

 

[Nikkidoshi]

I just checked with some users. They have access installed on their systems.

 

[RoryA]

It is possible to pull data from an Access db without having the actual access application, but if your code automates Access itself, then it won't work on a machine without it; if it doesn't automate access, then you shouldn't need the reference anyway.