I have a MS ACCESS DB (2007) created to quarterly capture “Performance” data on Public Health objectives/Measures to be statistically compared with a Target Number.
This is a relatively small DB. –No more than 40 users periodically providing data on no more than 200 Measures. The DB sits on a PH’ exclusively shared LAN’ server.
The main demand is to provide very sophisticated dashboards on the information provided. In this regard we have decided that another product that we own, IBM’ COGNOS, can do the best job.
For COGNOS to use the data I am importing the ACCESS tables into SQL. --Then from SQL to COGNOS.
Question #1: should I just quarterly update the SQL file, or simply link the 25 ACCESS tables to SQL? –Advantages/Disadvantages.
Question #2: if the best decision is to link the tables, should I do the ACCESS “split” -tables --from Queries, Forms, Reports?
Question # 3: After perhaps doing the above, is there a further advantage to giving the DB to the users as an “ACCDE” file?