#1
  1. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Pune, Maharashtra, India
    Posts
    86
    Rep Power
    15
    How can I use php with the ACCESS database till now i have conected to the MYSQL database only and used it as a back hand now I want to use ACCESS. Please list some standard functions also.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Posts
    300
    Rep Power
    15
    Asfar as I know you don't connect to Access itself, you place the Access database as one of the ODBC data sources and connect to that. It is quite easy, read the manual under the "ODBC" section. The basic functions are almost the same as with MySQL (I mean, they work almost the same). As for seting up the data source you will have to ask your SysAdmin to do that for you (unless you are the SysAdmin).
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Location
    Ontario, Canada
    Posts
    498
    Rep Power
    18
    I've done this before, and it's a little more complicated than using MySQL. First, you create your database through MS Access. Then, you go into "ODBC Data Sources" in the Control Panel, and click on the "System DSN" tab. Click on "Add", then select what type of database you want to link (it would be the top one, *.mdb.) Hit "finish", then give it a name -- this name is important, as it will be what you call it from in PHP. Next, select where the database itself lies in the Database box (push the "select" button.) After all that, your ODBC database is ready to go! As for PHP functions, either download the manual or refer to it online, as most of the functions resemble that of the MySQL functions.


    ------------------
    To alcohol! The cause of, and solution to, all of life's problems. -- Homer Simpson

Similar Threads

  1. Replies: 2
    Last Post: August 18th, 2004, 10:45 PM
  2. Replies: 4
    Last Post: January 28th, 2004, 08:29 AM
  3. PHP with UnixODBC
    By coder4hire in forum PHP Development
    Replies: 2
    Last Post: January 20th, 2004, 01:14 PM
  4. Passing string from PHP to Javascript
    By ka8oad in forum JavaScript Development
    Replies: 4
    Last Post: January 17th, 2004, 03:12 PM
  5. UnixODBC + PHP + Apache + Empress
    By coder4hire in forum Database Management
    Replies: 0
    Last Post: January 15th, 2004, 01:41 PM

IMN logo majestic logo threadwatch logo seochat tools logo