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!