Has anyone successfully linked up Excel with SQLite as a backend, some code examples would be appreciated? I'm currently using an .mdb successfully as a backend, but am running facefirst into some Access limitations. I would like to swap out SQLite for the mdb. Assume unfriendly IT department and that I won't be able to install an ODBC driver that all the users would be able to use, so I would prefer to direct connect like I do with the mdb.
View 9 RepliesI have designed an excel user form which can be used by managers to enter the delay hours for the employees which gets saved in excel. The form works fine I need to share this form to the managers. How can I do that ? I have individual worksheets for each managers and as soon as they enter the details in the user form the data gets stored in their respective sheets.
So how can I share this such that all the managers should be able to access it.
I was thinking if this is possible through web by saving my file as Html..
I am making an inventory system for a consultant who buys products and sells them at vendor shows. I have a simple table in Access that holds the quantity of each item the consultant has. I would like to be able to use Excel as a front-end interface for manipulating this data (through userforms). How might I be able to accomplish this? I'm fairly new to Access.
View 4 Replies View Related