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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Object Library Reference issue!
If they don't have Acess installed how can they save the data to
Access. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Object Library Reference issue!
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" wrote: If they don't have Acess installed how can they save the data to Access. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Object Library Reference issue!
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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Object Library Reference issue!
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" wrote: 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. |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Access Object Library Reference issue!
Eh, well kind of one of the main points of late-binding is you don't
need to use references. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
object library or invalid reference | Excel Programming | |||
How do I add a reference to an object library using VBA? | Excel Programming | |||
Reference to Office 11.0 Object Library | Excel Programming | |||
Setting a reference to an object library - do our customers have to do it too ? | Excel Programming | |||
Excel Object Library Reference | Excel Programming |