Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2009
    Posts
    8

    Unanswered: linked tables with mysql offline usage

    hi,

    i'm trying to link my access database to a mysql backend. this way the frontend would be access and the backend would be mysql.

    But here is the tricky part, would it be possible to work on this database offline if there is no access to the mysql server. And how can i do this?

  2. #2
    Join Date
    Nov 2007
    Posts
    93
    if the sql server is turned off then wonder how it gonna throw the data out of it

    and at the same time are the tables linked to sql ??

  3. #3
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    "Work on" does that mean modify the design of or does it mean run forms and want to manage the data?

    Typically, if the server goes offline, so does your application.

    You can reconfigure your app to hit a local MySQL server (one run in your own office)... I use WAMP to do so... but synchronising data when the server comes back online is not a trivial exercise.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  4. #4
    Join Date
    Mar 2009
    Posts
    8
    hmm,

    i was thinking of a way so that access caches the data when its offline, but i guess not

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    The problem is that you cannot predict when it goes offline and once it goes offline, the data is inaccessible, so you have to effectively continually maintain a local copy while the data is accessible. That results in pretty much defeating the purpose of having the MySQL server though -- and it slows down everything you do in the application.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •