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
|
Similar Threads
