User Profile

Collapse

Profile Sidebar

Collapse
mikeimp
mikeimp
Last Activity: Sep 9 '12, 05:47 PM
Joined: Apr 24 '12
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • mikeimp
    replied to VBA switch from local to remote database
    in Access
    Thanks for the info much appreciated...
    See more | Go to post

      Leave a comment:

    • mikeimp
      replied to VBA switch from local to remote database
      in Access
      If I set up the link using the Access ODBC tool then I have to use a DNS connection. I do not know how to set up a link any other way. The connection prior to tdf.refresh is SERVER=192.168. XXX.XXX; I am nervous about giving out the local IP address of the webserver so have replaced the numbers with X....
      See more | Go to post

        Leave a comment:

      • mikeimp
        started a topic VBA switch from local to remote database
        in Access

        VBA switch from local to remote database

        I am using a local 2010 Access Database linked to a MySQL Database using ODBC Driver 5.1.

        I want to easily switch from local linked tables on my development PC to a local network database.

        The server string localhost or 127.0.0.1 works fine but when changed to 192.168.xxx.xxx then I receive the message

        Run-time error '3146'
        ODBC --call failed



        Code:
        Function relinkTables(server
        ...
        See more | Go to post
        No activity results to display
        Show More
        Working...