Results 1 to 7 of 7
  1. #1
    ruycodo is offline Novice
    Windows XP Access 2021
    Join Date
    May 2023
    Posts
    3

    Update access automatically from another access

    I have a access_database which keeps on my own computer and another access_file which I use as a database to work with Excel dashboard, therefore everytime the user on dashboard selects a new filter, the VBA takes the information from this access_file to pull data, BUT my question is: Is there anyway to link automatically the access_file to access_database? Because every time I update the original file, I need to upload for the users to download once again.

    The flow would be, just to make easier:
    1) I update the access_database;
    2) It is linked via tables from access_database to acess_file which the access_file the users download;




    Thank you!

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    bring in your home db, place in a network share folder.
    The users db is linked to your db so they can get new data.

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Why don’t you just use the BE on the server instead of on your local machine?

  4. #4
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    So if I understand you correctly, OP, you have an access database file on a remote server and you copy and paste this file for use on your local machine?

    I would suggest you search Google about 'Microsoft access split database'. This will teach you about front-ends and back-end access database concepts.

    A word of caution: don't rely on a frontend/backend configuring if your local machine is using wireless internet, and don't do it if your backend isn't on the local network. If you were to do that it would lead to corruption.

  5. #5
    ruycodo is offline Novice
    Windows XP Access 2021
    Join Date
    May 2023
    Posts
    3
    Quote Originally Posted by ranman256 View Post
    bring in your home db, place in a network share folder.
    The users db is linked to your db so they can get new data.
    To have a commom network won't be possible due to IT rules. So that's why I asked about.

  6. #6
    ruycodo is offline Novice
    Windows XP Access 2021
    Join Date
    May 2023
    Posts
    3
    Would you have a link for me to study it? Sorry, I don't know about.

  7. #7
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142

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

Similar Threads

  1. Replies: 7
    Last Post: 09-19-2018, 09:26 AM
  2. Replies: 0
    Last Post: 05-15-2016, 11:18 AM
  3. Replies: 8
    Last Post: 05-08-2014, 09:51 AM
  4. automatically run report in access
    By cwang0129 in forum Access
    Replies: 1
    Last Post: 06-26-2012, 08:03 PM
  5. Set Access to automatically update
    By harrytgs in forum Access
    Replies: 3
    Last Post: 08-03-2011, 04:33 AM

Posting Permissions

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