Closed

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
Employer working
Skills Required
Project Budget
N/A
Total Bids
17
Project Description

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)

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online