Access Object Library Reference issue!

[sam]

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

 

[norie]

If they don't have Acess installed how can they save the data to
Access.

 

[sam]

they are not saving data to access, when they click submit they are sending
their inputs to me through outlook email. Then I open that attachemnt i
received in email and accept their inputs. I have access on my machine.

 

[norie]

So why do they need a reference to Access?

If you are the only person that needs it then you really should look
at late-binding, then you wouldn't have a problem with references.

 

[sam]

Thanks norie, I am getting late binding to work for access. Do you know how
get access reference to work with excel using late binding? or any sources
that I can refer to?

Thanks in advance

 

[norie]

Eh, well kind of one of the main points of late-binding is you don't
need to use references.