Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 5 of 5
  1. #1
    Regular Coder
    Join Date
    Dec 2005
    Posts
    217
    Thanks
    1
    Thanked 0 Times in 0 Posts

    How to connect MS Access?

    I want to use ms access with php .
    Has anybody used php with MS Access. If Yes would you not mind share a bit with me.
    Thanks in advance

  • #2
    Super Moderator guelphdad's Avatar
    Join Date
    Mar 2006
    Location
    St. Catharines, Ontario Canada
    Posts
    2,633
    Thanks
    4
    Thanked 148 Times in 139 Posts
    This is a forum for MySQL questions only. In future please post your access questions to the general database forum.

    I'll move the thread for you.

  • #3
    Regular Coder
    Join Date
    Dec 2005
    Posts
    217
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Pardon me..
    There is a section named other databases so i post this thread.
    By the way question is related to PHP.
    Or i m in dilemma?

  • #4
    teh Moderatorinator
    Join Date
    Sep 2004
    Location
    USA
    Posts
    2,472
    Thanks
    4
    Thanked 40 Times in 40 Posts
    Never had to do it myself, but ODBC? Or perhaps COM...yikes:
    ODBC (found on google):
    http://phplens.com/phpeverywhere/node/view/9

    Here's my google search:
    http://www.google.com/search?hl=en&c...access&spell=1

    Good luck.

  • #5
    Senior Coder
    Join Date
    Mar 2003
    Location
    Atlanta
    Posts
    1,037
    Thanks
    14
    Thanked 30 Times in 28 Posts
    It depends on your host. I'd check with them. Some have it set up where you have to set up a DSN. Is there any particular reason why you'd want to use Access?

    I haven't done this in forever but......

    If this is a local machine...and its using windows...you set up your DSN by going to: Control Panel > Administrative Tools > Data Sources (ODBC)

    Click the System DSN tab up top...

    Click Add.

    Find "Microsoft Access Driver" (its like the 6th or 7th one)

    Create a data source name. (something unique with no spaces)

    Click select and browse to your database.

    You can check out PHP.net to find out the scripting you'd have to use to talk to it tho.
    Most of my questions/posts are fairly straightforward and simple. I post long verbose messages in an attempt to be thorough.


  •  

    Posting Permissions

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