Page 1 of 2 12 LastLast
Results 1 to 15 of 17
  1. #1
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107

    Open database remotely

    Hopefully, this is the correct place for this question. I created an access database and split it, I want to run two copies of the front-end in parallel using a local network, the first on a windows PC and the second on an android-tablet



    I have only one PC, so I have to choose one of these two options:
    1. Install remote desktop app on the tablet, and work on the database remotely, but this will lock the PC during the remote session
    2. Install tools like team-viewer, but in this case this will create some chaos where the PC and the tablet are working both at the same time


    I also tried the following scenario, create two users on the PC, the first user logs in and runs the database, and then the tablets remotes the second user (which is not logged in of course), but still the same problem, the PC is locked during the remote session.

    Any idea how to open the database on the tablet without affecting the PC?
    Last edited by bilalo; 04-12-2020 at 05:09 AM.

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Don't do it. Sharing a database is a recipe for corruption.
    Instead split the database, place the BE on the network and a copy of the FE on both desktop and tablet.
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Quote Originally Posted by isladogs View Post
    Don't do it. Sharing a database is a recipe for corruption.
    Instead split the database, place the BE on the network and a copy of the FE on both desktop and tablet.
    My database is already split.
    How do I place a copy of the access FE on android-tablet / IPad ?

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by bilalo View Post
    My database is already split.
    How do I place a copy of the access FE on android-tablet / IPad ?
    If the back end is Access the front ends need to be on a wired network.
    You'll need to change the back end to something else like SQL server or MySQL if the connection is to e wireless.
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Quote Originally Posted by Bob Fitz View Post
    If the back end is Access the front ends need to be on a wired network.
    You'll need to change the back end to something else like SQL server or MySQL if the connection is to e wireless.
    How does that help with running MS access front-end on an android-tablet?

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Quote Originally Posted by bilalo View Post
    My database is already split.
    How do I place a copy of the access FE on android-tablet / IPad ?
    You can't. Access is Windows only.
    I am currently using an inexpensive Windows tablet which has Access installed. It works well ...but Bob's warning about wireless networks is worth following
    Otherwise you will need to use Teamviewer or similar but you still need two separate copies of the FE
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 10 Access 2016
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Quote Originally Posted by bilalo View Post
    How does that help with running MS access front-end on an android-tablet?
    Will the android-tablet be wired to the network?
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  8. #8
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Quote Originally Posted by isladogs View Post
    You can't. Access is Windows only.
    I am currently using an inexpensive Windows tablet which has Access installed. It works well ...but Bob's warning about wireless networks is worth following
    Otherwise you will need to use Teamviewer or similar but you still need two separate copies of the FE
    Exactly, for Windows tablets, there is no problem at all, i can connect them directly to the network. My problem is with non-windows tablets

  9. #9
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Quote Originally Posted by Bob Fitz View Post
    Will the android-tablet be wired to the network?
    No, It is a wireless connection. But I am still not getting your point, how is wireless/wired connection related to my case?

  10. #10
    kd2017 is offline Well, I tried at least.
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    1,142
    Quote Originally Posted by bilalo View Post
    No, It is a wireless connection. But I am still not getting your point, how is wireless/wired connection related to my case?
    They're saying it's a bad idea to use your database over a network through a wireless connection, eg a tablet. It could cause corruption of your DB file. Using Access over a network should be limited to wired connection devices.

  11. #11
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Ah ok, so MS Access is not designed for wireless usage. This means that the best choice here is to remote control the PC from the tablet.
    Hopefully I can find a way to allow the tablet to remote control the PC without affecting the logged user

  12. #12
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    How do I place a copy of the access FE on android-tablet / IPad ?
    you could try installing a windows virtual machine on your android device - but don't know of one that would work so may be a none starter - a quick google found this https://www.quora.com/Is-there-any-g...pp-for-Android.

    the safest option is to use terminal server or citrix with remote desktop - or get a spare networked computer for the android device to connect to using teamviewer or similar

  13. #13
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Quote Originally Posted by Ajax View Post
    you could try installing a windows virtual machine on your android device - but don't know of one that would work so may be a none starter - a quick google found this https://www.quora.com/Is-there-any-g...pp-for-Android.

    the safest option is to use terminal server or citrix with remote desktop - or get a spare networked computer for the android device to connect to using teamviewer or similar
    It seems that it is not safe to use MS access database over wireless network, this could lead to db corruption. I am running out of ideas, there is only one solution left to me, to use another networked computer that is reserved for the tablet.

  14. #14
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    if wireless is a requirement, consider using sql server express as a backend and make sure each user uses a compiled version of the front end (.accde). That should minimise the risk of corruption occurring,

  15. #15
    bilalo is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2019
    Posts
    107
    Quote Originally Posted by Ajax View Post
    if wireless is a requirement, consider using sql server express as a backend and make sure each user uses a compiled version of the front end (.accde). That should minimise the risk of corruption occurring,
    Regarding the font-end, I never work with non-compiled versions.
    As for the back-end, eliminating corruption is a priority, I think I am going to switch to another db type.
    Thank you

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Issues with database when working remotely
    By wolfm in forum Database Design
    Replies: 3
    Last Post: 11-01-2019, 01:24 AM
  2. How to Add/Edit records remotely
    By Athar Khan in forum Access
    Replies: 17
    Last Post: 10-02-2017, 04:03 PM
  3. Remotely sharing a complex access db
    By MS123 in forum Access
    Replies: 5
    Last Post: 11-28-2016, 10:32 AM
  4. Using Access Remotely - Do I need SharePoint?
    By kevins in forum SharePoint
    Replies: 1
    Last Post: 01-17-2012, 02:53 PM
  5. Accessing my inventory remotely
    By Steven in forum Access
    Replies: 2
    Last Post: 02-27-2010, 11:56 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