Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Object Library Reference issue!
Hi All,
I have created a system consisting of excel and access. Here is how it works. I have created an excel userform, employees in my company use this userform to input data and click €śSubmit€ť button on userform. Once they click submit (on userform) the inputs are then emailed to me as an excel attachment. Now in this attachment I have an "Accept" button. Once I hit accept, these inputs are then stored in access database. The ISSUE! Not all people in my company are authorized for access. That is, they dont have Microsoft access installed on their machines. To make this system work, I have to check the "Tools-----References---Microsoft Access 12.0 Object Library" in the original form where employees input data. Now, as other employees dont have access installed on their machines, They get an error when they input the data and click submit, as I have "Tools---References---Microsoft Access 12.0 Object Library" checked and it shows "Missing" on other employees machines. Only I have access and the company is not willing to provide access to everyone. If I uncheck the "Tools---References---Microsoft Access 12.0 Object Library" then the employees are able to submit their inputs. BUT then I cannot use the accept button to populate access database as "Tools---References---Microsoft Access 12.0 Object Library" is unchecked and it gives me an error. I hope I made it clear. PLEASE HELP!! Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Access Object Library Reference issue! | Excel Programming | |||
Access Object Library Reference issue! | Excel Programming | |||
object library or invalid reference | Excel Programming | |||
How do I add a reference to an object library using VBA? | Excel Programming | |||
Excel Object Library Reference | Excel Programming |