- Local time
- Today, 06:44
- Joined
- Feb 19, 2013
- Messages
- 16,637
probably a silly question. My guess is no but thought worth asking in case anyone has been faced with this situation.
Background: I have a new client who uses office 365 (all users). There are a number of users who (perhaps) do not have Access installed but want to regularly refresh some data in excel spreadsheets (primarily lookup tables).
They do have 'line of sight' across the LAN to the folder where the access backend is installed and my thinking was they could run an Excel macro to open an instance of access and extract the data.
Alternative is to use ADO, but again, not sure if ODBC would include the Access driver if Access not installed.
All depends on what gets installed when Office 365 is installed. The client has a substantial IT dept with the usual long winded method for getting anything considered, let alone done and the project has a go-live across 26 countries in two weeks time.
What I don't know is if the 365 installation includes the access library dll, even if Access itself is not installed. In total there are around 60 users who do not have access installed (or to be more precise, they don't use it so don't know!)
I don't have a setup that does not include Access (and to uninstall may still leave stuff behind) to test the scenario. I can test on the user machines but this will take time and I would prefer to go in knowing the answer rather than suggesting a possible solution that doesn't work out.
I have a workaround - basically maintaining a master excel file from access which users copy across when required, but not very satisfactory long term.
A better alternative is to replace the Excel 'front end' with an Access one but this is a longer term solution, no way can it be completed and test in the available two weeks.
So to summarise, can anyone confirm one way or the other whether an Office 365 installation will automatically include the access dll and/or driver?
Background: I have a new client who uses office 365 (all users). There are a number of users who (perhaps) do not have Access installed but want to regularly refresh some data in excel spreadsheets (primarily lookup tables).
They do have 'line of sight' across the LAN to the folder where the access backend is installed and my thinking was they could run an Excel macro to open an instance of access and extract the data.
Alternative is to use ADO, but again, not sure if ODBC would include the Access driver if Access not installed.
All depends on what gets installed when Office 365 is installed. The client has a substantial IT dept with the usual long winded method for getting anything considered, let alone done and the project has a go-live across 26 countries in two weeks time.
What I don't know is if the 365 installation includes the access library dll, even if Access itself is not installed. In total there are around 60 users who do not have access installed (or to be more precise, they don't use it so don't know!)
I don't have a setup that does not include Access (and to uninstall may still leave stuff behind) to test the scenario. I can test on the user machines but this will take time and I would prefer to go in knowing the answer rather than suggesting a possible solution that doesn't work out.
I have a workaround - basically maintaining a master excel file from access which users copy across when required, but not very satisfactory long term.
A better alternative is to replace the Excel 'front end' with an Access one but this is a longer term solution, no way can it be completed and test in the available two weeks.
So to summarise, can anyone confirm one way or the other whether an Office 365 installation will automatically include the access dll and/or driver?