Excel 'app' with MS Access backend

winshent

New Member
Joined
Jun 30, 2008
Messages
19
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
 

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Forum statistics

Threads
1,136,328
Messages
5,675,136
Members
419,551
Latest member
thangxpm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top