Hi ,
Please let me know the feasibility of doing this. I hope you are good in MS Access. The requirements as follows.
We have 26 sheets (23 Input sheets and 3 dashboards) that need to be interlinked.
We tried linking through a Master database file but it's taking very long time for macro to update the master after each file is updated
Create Access database with each table (sheets) linked by product ID and link each sheets to the appropriate tables in Access. I think this way access tables and excel sheets are updated in real time
So when you open the excel you it should fetch data from its access table in the mapped Access DB. And any change made in excel should be updated in the same table in the same Access DB.
And the access tables should be inter liked with unique Ids, so if one table is updated with the change made in its excel then all tables which are linked should be automatically updated. so when we open the excel file mapped to that table, the updated data should be obtained.
Please not the following.
Don't take long time for files to open/close/update
Allow multiple users using the files (at any point only one user will use the sheets but users can use different sheets at the same time. for example Malaysia Medical can be used while Malaysia Regulatory is used)
i have 7 years of MNC corporate experience in working on excel and MS access. I promise to deliver the final solution in 3 days of getting the project.
I am experienced in all Office programs and VBA. Currently I am giving MIS lectures at a university where I am teaching how to collaborate Office programs effectively, especially Excel and Access.
I have experience in developing software solutions to factories and electrical power stations. I am lunching my profile in this site, so I am giving max service with lowest price. I will develop you whatever you want and more, with min price you expect or less.