Results 1 to 9 of 9
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    How to connect from local computer to database on vpn server

    Hi Guys,

    i want to give possibility for users to connect from Access FE to database on vpn remote server.
    What connections should i use?



    And how to manage this?

    My steps to log manually on remote server with database:
    1. Connecting to vpn giving user and password (Cisco any connect software)
    2. Connecting to virtual machine with ubuntu with VNC viewer, giving IP and password.

    Please help,
    Best,
    Jacek

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    I don't think you can.

  3. #3
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Hmm it is not possible?

    Are you sure?

    Best,
    Jacek

  4. #4
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I would say it is more of "It depends".

    Is the dB split into a FE and a BE?

    The problem with connecting a FE to a BE over a WAN ( or even a LAN sometimes) is that if the BE is Access, a loss of connection will corrupt the BE.
    IIRC, this also affect SQLS linked tables (when using DAO).

    You *might* be able to use ADO (instead of DAO) over a WAN; I have never tried it. What we did when we moved to the 'cloud' was everyone had their own VM (with the FE) which was connected to the "Main Server" (the BE) and used RDP to access the VM/dB.

    This also allows the Mac users to have access to the dB.

  5. #5
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Hi Steve,

    thank you!

    The problem with connecting a FE to a BE over a WAN ( or even a LAN sometimes) is that if the BE is Access, a loss of connection will corrupt the BE.
    IIRC, this also affect SQLS linked tables (when using DAO).
    i prefer to use ODBC connection so it should be ok.

    Access is FE for postgresql BE. Access is on VM with windows and postgresql is based on VM with linux.

    What i want to achieve?

    1. Create workbook's macro where user can connect from local computer to VM with windows,
    like here: https://social.msdn.microsoft.com/Fo...orum=vbgeneral

    Question: which kind connection: OleDb or ODBC i should use for Access FE?

    2. Connect from Access FE to Postgresql with ODBC i think. Postgresql is on linux in other VM.

    Question: if i want to connect using odbc i should install odbc driver for postgresql also on linux VM?

    thank you for help,
    Best,
    Jacek

  6. #6
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by jaryszek View Post
    i prefer to use ODBC connection so it should be ok.
    Don't count on it. ODBC is a 'translator' that allows one DBMS to talk to a different DBMS. It is not the WAN/LAN.
    Lets say you are using a laptop at the airport to do some last minute edits of data. You are connected wirelessly. If the data is being written to a table and the connection drops for a nanosecond, the data could be corrupted. You also could conceivably wipe out/corrupt your hard drive.


    Quote Originally Posted by jaryszek View Post
    Question: which kind connection: OleDb or ODBC i should use for Access FE?
    The question is more "What is the BE?". The API must be available for Access for the desired BE.

    Read these:
    https://en.wikipedia.org/wiki/OLE_DB Find/Read "Support Status".
    https://en.wikipedia.org/wiki/Open_D...e_Connectivity Find/Read "ODBC today".



    Quote Originally Posted by jaryszek View Post
    Question: if i want to connect using odbc i should install odbc driver for postgresql also on linux VM?
    Again, OBDC is a translation API to convert/translate Access SQL into SQL that PostgreSQL uses/can understand. So the ODBC should be on the Access computer.





    I am treading water on this (in way over my depth), but that is my understanding on this subject.

    Hopefully others better versed will respond...

  7. #7
    Join Date
    Apr 2017
    Posts
    1,673
    Isn't there no terminal server in location of VM with BE. Place FE for every user in this user's profile in TS. User connects through VM to TS, and opens FE from there.

  8. #8
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Hi Steve,
    thank you!

    Hi ArviLaanemets,

    thank you.
    It is the best option.

    Now i have license for office in windows server and can do it.
    And i am thinking that having BE on other server and connectint to it wiressly can trigger database corruption.

    Best,
    Jacek

  9. #9
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by jaryszek View Post
    And i am thinking that having BE on other server and connectint to it wiressly can trigger database corruption.
    I am basing my comments on this article by Albert D. Kallal Using a wan with ms-access? How fast, how far?
    A little dated, but still informative IMHO.


    Good luck with your project....

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

Similar Threads

  1. How to connect from local FE to remote database?
    By jaryszek in forum Database Design
    Replies: 4
    Last Post: 05-25-2018, 03:11 AM
  2. Replies: 9
    Last Post: 11-28-2017, 05:23 AM
  3. Replies: 23
    Last Post: 07-09-2014, 02:16 PM
  4. Connect access from workstation to sql server database
    By danieltaylor in forum SQL Server
    Replies: 1
    Last Post: 11-26-2012, 03:11 PM
  5. Replies: 1
    Last Post: 05-25-2012, 10:36 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