Professional Web Applications Themes

Copy database from MySQL to MSAccess - PHP Development

Hi there, I'd like to have a template DB stored with MySQL from which I later can create clientDB's for use with MSAccess. I've read that I can connect to MSAccess with PHP through ODBC and that's fine but how do I transfer the tables and cusomized data? TIA /Kjell Hansen...

  1. #1

    Default Copy database from MySQL to MSAccess

    Hi there,
    I'd like to have a template DB stored with MySQL from which I later can
    create clientDB's for use with MSAccess.
    I've read that I can connect to MSAccess with PHP through ODBC and that's
    fine but how do I transfer the tables and cusomized data?

    TIA
    /Kjell Hansen
    Kjell Hansen Guest

  2. #2

    Default Re: Copy database from MySQL to MSAccess

    Hi Kjell

    I'm not sure whether you are transferring from within the webserver, or from
    the webserver to MS locally, but either way I'd set up the MS database
    locally. Just install the MySQL ODBC driver (I think its at the mysql.com
    website) and link all the MySQL tables to your MS Access database and just
    import the tables using the processes within Access itself.

    Afterwards you can transfer the Access database up to the server.

    If you are doing the database functions wholly within the server you might
    consider using the Pear DB database abstraction layer to make it simplier.
    (That's how I'd do it anyway).

    Cheers
    Leonie

    "Kjell Hansen" <kjell.hansensaj.fi> wrote in message
    news:20030902054950.27750.qmailpb1.pair.com...
    > Hi there,
    > I'd like to have a template DB stored with MySQL from which I later can
    > create clientDB's for use with MSAccess.
    > I've read that I can connect to MSAccess with PHP through ODBC and that's
    > fine but how do I transfer the tables and cusomized data?
    >
    > TIA
    > /Kjell Hansen
    Leonie Guest

  3. #3

    Default Re: Copy database from MySQL to MSAccess

    Try

    [url]http://php.weblogs.com/adodb[/url]

    hope this helps....


    "Leonie" <leonie_pricehotmail.com> wrote in message
    news:20030902062342.64832.qmailpb1.pair.com...
    > Hi Kjell
    >
    > I'm not sure whether you are transferring from within the webserver, or
    from
    > the webserver to MS locally, but either way I'd set up the MS database
    > locally. Just install the MySQL ODBC driver (I think its at the mysql.com
    > website) and link all the MySQL tables to your MS Access database and just
    > import the tables using the processes within Access itself.
    >
    > Afterwards you can transfer the Access database up to the server.
    >
    > If you are doing the database functions wholly within the server you might
    > consider using the Pear DB database abstraction layer to make it simplier.
    > (That's how I'd do it anyway).
    >
    > Cheers
    > Leonie
    >
    > "Kjell Hansen" <kjell.hansensaj.fi> wrote in message
    > news:20030902054950.27750.qmailpb1.pair.com...
    > > Hi there,
    > > I'd like to have a template DB stored with MySQL from which I later can
    > > create clientDB's for use with MSAccess.
    > > I've read that I can connect to MSAccess with PHP through ODBC and
    that's
    > > fine but how do I transfer the tables and cusomized data?
    > >
    > > TIA
    > > /Kjell Hansen

    point Guest

  4. #4

    Default Re: Copy database from MySQL to MSAccess

    Hi Leonie
    My approach is to have the empty AccessDB on the server. Make a copy of it
    and insert all the tables into the copy and then have it downloaded from the
    server. So I'm actually never gonna use Access, it's just the database I'm
    using for storage of data.

    One way of doing this could be to store the table definitions as
    SQL-statements in another table, but I'm not very thrilled about that idea.

    TIA
    /Kjell Hansen
    Kjell Hansen Guest

Similar Threads

  1. MySQL Copy Row
    By dogManifesto in forum PHP Development
    Replies: 1
    Last Post: April 10th, 04:45 PM
  2. Cannot use MSAccess database on WorkGroup with ASP
    By Yall in forum ASP.NET Web Services
    Replies: 1
    Last Post: January 12th, 12:07 AM
  3. Unable to connect to MSAccess database
    By Joe Abou Jaoude in forum ASP Database
    Replies: 2
    Last Post: April 19th, 11:17 AM
  4. How to copy records from one database to another one ?
    By Jesus Gonzalez in forum FileMaker
    Replies: 3
    Last Post: June 28th, 03:03 PM
  5. Copy Database from NT to W2K
    By Giuseppe in forum Oracle Server
    Replies: 3
    Last Post: December 26th, 11:39 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139