Results 1 to 7 of 7
  1. #1
    Ant_Snell is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    118

    How to Install MySQL onto a VPN

    I have an Access DB and want to link a split backend from MySQL tables on a VPN. Before last week I had never seen/used MySQL but after several try’s I did manage to install MySQL, workbench and ODBC drivers locally on my Windows PC, then export the Access tables to it and re-Link SQL tables back to Access frontend . However when trying to install onto a VPN, the default location is C:\..... and I can see no option to change it. If I look at the Security Properties of the VPN, it says “root (Unix User\root)” so I am assuming the MySQL install should be a Unix version?



    Can anyone help with simple steps on how to install on a VPN?
    Thanks

  2. #2
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    You don't install onto VPN as such.
    A VPN is a Virtual extension to your network, and therefore your backend (regardless of what it is) need to be installed on a server that location is connected to.

    So If it's a Unix server then yes you'll need to install Unix version of MySQL.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  3. #3
    Ant_Snell is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    118
    Hi Minty, Thanks, that's starting to make sense, I'll have a go.

  4. #4
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Be warned that a VPN connected back end can be painfully slow unless you are on a really good VPN connection, gigabit both ends and in the middle
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  5. #5
    Ant_Snell is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    118
    Ahh, OK thanks, speed was one of two reasons to go SQL. The other was so that a smaller Power Apps application could be web accessed. What would be the best resolution for multiple users to access the Access DB and a smaller amount of users access same DB via a phone app?

  6. #6
    Minty is online now VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    We do a lot of development on Azure SQL hosted backends, and you need to design to accommodate where the data is stored and the way data is moved around.
    Generally they work very well, but you do need to build with the constraints in mind.

    Some issues / points to consider;

    • Keep and use Local Copies of rarely changing lookup tables
    • Move complex joins of main tables into Views from the server.
    • Use Pass through Queries to run Stored Procedures and return complex data sets (Use the server to do the heavy lifting)
    • Load forms with a minimum or no data. Use a search to populate with one record or a smaller subset of records.
    • Tons of other stuff I can't remember, but probably do automatically...


    A SQL backend will be far more resilient than an Access backend, that is for certain over a WAN type connection.
    I am currently using a couple of Power Automate Flows to automate certain functions with SQL in Azure and it seems a pretty good solution base.

    A VPN is only as good as the connections. If you can you could use remote desktop in conjunction with the VPN then speed issues disappear as effectively you are on the same server.
    You aren't relying on the outside world connections anything like as much. Just passing Screen data and Keyboard input.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  7. #7
    Ant_Snell is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Jul 2021
    Location
    UK
    Posts
    118
    Thanks Minty!

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

Similar Threads

  1. Print view MySQL Database Install problems!
    By spadekevin in forum Misc
    Replies: 1
    Last Post: 06-29-2018, 11:07 AM
  2. install 64-bit and 32-bit
    By azhar2006 in forum Access
    Replies: 2
    Last Post: 10-24-2014, 12:37 PM
  3. Runtime Install
    By headcase in forum Access
    Replies: 1
    Last Post: 02-01-2011, 11:11 AM
  4. Runtime Erro will not install
    By drunkinmunki in forum Access
    Replies: 4
    Last Post: 12-16-2010, 06:56 AM
  5. Replies: 1
    Last Post: 12-06-2010, 08:38 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
  •  
Other Forums: Microsoft Office Forums