Results 1 to 2 of 2
  1. #1
    shkspeare is offline Novice
    Windows 10 Office 365
    Join Date
    Sep 2020
    Posts
    6

    check remote connection at startup and thru out session

    I'm working with an o365 Front end, linked to mysql backend on aws rds. I'm at point of testing for no connection, or if the connection drops while access is open.

    For now, when i force loss of connection - first it opens up the odbc mysql login form - then some error messages - then odbc 3151...it's messy. I've tried to trap this 3151, but does not ever get to the error handler.

    I wonder if would be helpful to check the network status at startup, and then at intervals perhaps. I would think I would just have to test that the internet connection is up.



    Ideally, I'd like to handle and trap this loss of connection, in clean way for the users (message saying 'no connection - try again later,' - and then shutting down Access without all the other errors..

    any feedback, suggestions welcome!

    thanks!

  2. #2
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    Checking the status at regular intervals won't do much: you can check it, find it OK and then 3 secs later it's gone. Checking at the startup seems a valid option: maybe have a look here : https://stackoverflow.com/questions/...dbc-connection

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

Similar Threads

  1. Replies: 11
    Last Post: 07-13-2018, 04:43 PM
  2. Replies: 11
    Last Post: 01-10-2017, 08:53 PM
  3. Connection lost from mysql remote odbc with MS Access
    By zeeshanaslamdurrani in forum Code Repository
    Replies: 1
    Last Post: 02-21-2016, 07:13 AM
  4. Remote Desktop Connection Broker connection string
    By Philosophaie in forum Access
    Replies: 1
    Last Post: 09-14-2015, 03:51 PM
  5. Trying to check a remote connection!
    By Zermoth in forum Programming
    Replies: 1
    Last Post: 12-11-2008, 05:15 AM

Tags for this Thread

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