#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Nov 2000
    Posts
    2
    Rep Power
    0
    Hello,
    I maintain my table in Access then export them to the MySQL database via ODBC. What I would like to do is overwrite the entire table each time, but instead I need to telnet in to the serv er, select the database, drop the table and then re-export the table from Access.

    I want to dispense with dropping the table and overwrite the whole thing - Can it be done?
  2. #2
  3. No Profile Picture
    Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Sep 2000
    Location
    Colchester, England
    Posts
    131
    Rep Power
    15
    Several ways to do this I am sure there are more.

    1. Dispense with updating locally and create a link table to the MySql database and point your forms to this link.

    2. If you want to update offline still create a link to the table and create a query to delete the contents of the linked table. Create another query to copy from the local table to the linked table.

    3. Create a pass through query to drop the table, another pass through query to create it. Populate with an update query as in "2".

    4. Get someone else to do your original way for you!

    Andy

Similar Threads

  1. Replies: 3
    Last Post: February 11th, 2004, 08:30 AM
  2. Replies: 1
    Last Post: January 30th, 2004, 06:04 PM
  3. how to keep table on top, not centered??
    By vinyl in forum HTML Programming
    Replies: 2
    Last Post: January 20th, 2004, 06:19 PM
  4. Scratch table error in MySQL
    By byte me in forum MySQL Help
    Replies: 11
    Last Post: January 20th, 2004, 11:51 AM
  5. Replies: 1
    Last Post: January 16th, 2004, 07:39 PM

IMN logo majestic logo threadwatch logo seochat tools logo