SitePoint Sponsor

User Tag List

Results 1 to 8 of 8
  1. #1
    SitePoint Guru tombempty's Avatar
    Join Date
    Oct 2001
    Location
    New York
    Posts
    688
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    I need an easy my_sql software....

    Hello All:

    My managers wanted me to create a php script and my_sql database to collect some information on the internet of people who fill out our online form which I did.

    Now, they want to be able to access this db and do marketing stuff with it. I could easily do this on a monthly basis for them but I was wondering if there was an easy dumbed down version that like a receptionist could use.

    Not to insult anyone here, just something not so techy as phpmyadmin or mysql tools that a layperson would understand. Be able to access the DB download/export it to a CVS file or something.

    Thanks for any advice anyone has,

    Paul
    ********
    Regards,

    P

  2. #2
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,250
    Mentioned
    59 Post(s)
    Tagged
    3 Thread(s)
    sure

    microsoft access, with linked tables to mysql
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  3. #3
    SitePoint Guru tombempty's Avatar
    Join Date
    Oct 2001
    Location
    New York
    Posts
    688
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    oh yeah... I almost forgot about them. LOL thanks
    ********
    Regards,

    P

  4. #4
    SitePoint Wizard
    Join Date
    Jul 2003
    Location
    Kent
    Posts
    1,921
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Has anyone had a problem linking Access 2003 to mysql?

    I've had no problem using access 2000, but a friend who does this every day at work using 2000, has been failing miserably to get it to work using 2003 at another site.

  5. #5
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    it works for me, and i do it regularly with 2000, 2003 and 2007.

  6. #6
    SitePoint Wizard
    Join Date
    Jul 2003
    Location
    Kent
    Posts
    1,921
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Thanks, must be something else causing the problems.
    My antique laptop connected via Access 2000, and three other machines on the same network, all with Access 2003, failed to show any tables, but apparently connect to the database.

  7. #7
    reads the ********* Crier silver trophybronze trophy longneck's Avatar
    Join Date
    Feb 2004
    Location
    Tampa, FL (US)
    Posts
    9,854
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    how was the link accomplished? if myodbc was used, then it would have to be installed on all of the computers where the database is used, plus have correct ODBC entries made.

  8. #8
    SitePoint Wizard
    Join Date
    Jul 2003
    Location
    Kent
    Posts
    1,921
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)
    Yes, myodbc was used and the latest driver downloaded onto each computer a second time to be sure we all had the same version.
    We went through every entry in the set-up on my working laptop and the office PCs with a fine tooth comb and could find no differences.
    Very frustrating. Especially as it took about one minute to get it working on my laptop after downloading the driver, and I hadn't even done this for a while and was a bit rusty. I definitely don't think I did anything clever to make it work either.

    The only difference was I had access 2000 and they had 2003.


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
  •