VBA and Excel Access Collaboration
This project received 17 bids from talented freelancers with an average bid price of $226 USD.Get free quotes for a project like this
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)
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online