Results 1 to 6 of 6
  1. #1
    ridwan is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Location
    Bangladesh
    Posts
    4

    Exclamation linked table update of mysql database from access database

    Hello,
    i am trying to send table data from access database to mysql database and the data sending should be automated. I never worked with access database or VB. I searched google but did not find a proper solution for this. Does anyone worked with the similar problem or have any suggestions?



    Thanks
    Ridwan

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    What do you mean by automated? Some event must take place for behavior to happen, such as project opening and running an autoexec macro or a form opening or a button click.

    And the 'send' would be an UPDATE or INSERT sql?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ridwan is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Location
    Bangladesh
    Posts
    4
    What i mean is when i create a link between the Access Database and Mysql, is there any way the table data in Mysql will be automatically updated from the Access database after exporting the first time?
    My Access table is updated every hour. How can i synchronize the transfer of data between the two database?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Sorry, SQL Server automation is beyond my experience. I did a google search on 'access automatic update to sql server' and read some threads but none make sense to me, such as http://www.sqlmonster.com/Uwe/Forum....te-From-Access
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    ridwan is offline Novice
    Windows XP Access 2007
    Join Date
    May 2012
    Location
    Bangladesh
    Posts
    4
    Thank you for your quick reply.
    I searched google also but the result was same. None of them worked properly for this problem. I am new with the Access Database. Is there any possibility of doing something with the macro in the access database?

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    I doubt macros offer a solution. From what little I read it sounds like the automation would have to be from the SQL Server side. But like I said, beyond my experience.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Need help getting Access 2010 database into MySQL
    By mosk in forum Import/Export Data
    Replies: 1
    Last Post: 01-22-2012, 05:21 PM
  2. Replies: 1
    Last Post: 11-25-2011, 11:16 AM
  3. Replies: 1
    Last Post: 08-30-2011, 11:54 PM
  4. Export MySQL database into Access
    By Yesideez in forum Import/Export Data
    Replies: 6
    Last Post: 08-08-2011, 12:13 PM
  5. Access database to Mysql
    By fsmikwen in forum Access
    Replies: 4
    Last Post: 11-16-2009, 05:40 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