I've been asked to develop a management information pack, which will plug in to a centrally shared datasource.
Typically i would develop an Access DB, but in this case i think excel might be better as the layout of the reporting pack which they want me to copy, cannot be easily duplicated with Access reports.
So, i'm exploring developing an excel app, that will connect to the database. And my main question is where to locate the queries. Should i build queries in the back end access db file.. or locate some MS Query files on the shared drive for all users apps to pull data from?
I know that when creating a multi user Access database system, its only the data that sits in the back end file... Whats the best option in this case?
Vince
Typically i would develop an Access DB, but in this case i think excel might be better as the layout of the reporting pack which they want me to copy, cannot be easily duplicated with Access reports.
So, i'm exploring developing an excel app, that will connect to the database. And my main question is where to locate the queries. Should i build queries in the back end access db file.. or locate some MS Query files on the shared drive for all users apps to pull data from?
I know that when creating a multi user Access database system, its only the data that sits in the back end file... Whats the best option in this case?
Vince
