Results 1 to 3 of 3

How to link Access to Excel and update both ways?

  1. #1
    JennyL is offline Novice
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    15

    How to link Access to Excel and update both ways?

    Hi all,

    I am new to this forum hoping someone can help me with my Access issue. I am currently building a Setup Profile database which will be used by about 10 users. I am planning to split the database after everything is done. My problem now is that some users work from home on some days and we have to access through VPN. I do not want users to access the database through VPN because it will most likely crash. I am trying to come up with a work around for these users when they are working from home. I created excel with connection to Microsoft Query (Access Database) and it works great for users to read and research the data when they cannot access the database. However, if a user needs to update the information, the change does not feed back to Access Database. Any recommendations on what I need to build so that users can use Database at work, but use either excel or another application to add or edit the information and feed back to access when they need to work from home through VPN?



    Thank you in advance!

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    4,332
    I work with access via VPN. It works fine. no crashes.
    you can work in excel, which access can read as a table,
    you cannot work in Access to update live excel. you must export access to excel.

  3. #3
    JennyL is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2017
    Posts
    15
    Thanks for the response Ranman256. Not sure how my VPN is setup but whenever we try to open the access, it will always crash that's why I am so afraid of letting users using it when they work from home. I am looking for a workaround as backup option. I started connecting access to sharepoint but then it removed the relationship among my tables so that's not going to work.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 04-16-2014, 06:07 AM
  2. Link to Excel; number of records change and Excel can't update
    By crobaseball in forum Import/Export Data
    Replies: 5
    Last Post: 03-22-2014, 10:40 PM
  3. Link excel to access
    By medaccess in forum Programming
    Replies: 7
    Last Post: 04-28-2013, 06:03 PM
  4. One Way Link From Access to Excel
    By dargo72 in forum Import/Export Data
    Replies: 1
    Last Post: 12-06-2012, 12:31 PM
  5. link between excel and ms-access
    By Bala Preetha in forum Access
    Replies: 1
    Last Post: 11-28-2010, 07:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Tech Forums: Microsoft Office Forums