Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2004
    Posts
    109

    Modifying An Access Database

    My company has an online timesheet program which uses Access as its database. From time to time it messes up and I have to download the database to my computer, fix it, and then reupload it. I don't know enough about ASP to fix the problem in the code by myself but I was wondering if there is anything available, similar to phpMyAdmin, that will allow me to modify the Access database without the need to download and upload it.

  2. #2
    Join Date
    Jul 2003
    Location
    laredo
    Posts
    303
    I don't know about a CMS. You can build your own.

    Are you trying to update the structure of the table or just the data inside of it. I use the following to update the data without having to downloade it. I use php though.

    <?
    $conn = new COM("ADODB.Connection") or die("Cannot start ADO");
    // Microsoft Access connection string.
    $conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=C:\\path\\to\\your\\database.mdb");
    // SQL statement to build recordset

    ?>

    <?
    $rs = $conn->Execute("UPDATE yourtable SET

    something = '{$_POST['something']}',
    somethingelse='{$_POST['somethingelse']}'

    WHERE id={$_POST['id']}");

    $rs->Close();
    ?>

    If you are looking for something easier, look into using Front Page, It can tackle that.

  3. #3
    Join Date
    Nov 2004
    Posts
    109
    My only option is ASP, which I don't really know that well. There's no phpMyAdmin type program made for ASP to work with Access databases?

  4. #4
    Join Date
    Mar 2006
    Posts
    965
    phpmyadmin is only PHP interface (for now).

  5. #5
    Join Date
    Nov 2004
    Posts
    109
    I understand that, I don't want phpMyAdmin, I want a program that acts like phpMyAdmin, but uses ASP and Access.

  6. #6
    Join Date
    Mar 2006
    Posts
    965
    You can always visit: http://www.hotscripts.com to see if there aren't any relative utilities on ASP.

Posting Permissions

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