PHP + Access

Zep

Salam, aku ada dapat projek untuk buat sistem guna PHP + Access as db. PHP takde problem lah cuma nak guna access as db tu problem skit. rasa2 reliable ke pakai access ni? tak silap aku kena connect odbc bagai kan? aku pun buntu macam mana nak mulakan ni. apa sape2 sudi berkongsi ilmu?

BorderManager

kenapa tak guna MySQL je...
dulu pernah guna Access n... problem bila nak buat paging sebab access xde LIMIT
lain ko kena install ODBC driver dulu...

aziz79

aku tak pernah guna PHP dgn access.. memeningkan..
Mcm border manager ckp, MySQL lagi mudah..

aLieNzDaToR

aku pon tak reti nak bagi idea kalo guna access ni. asal tak guna mysql je? database access tu ko convert jd sql file ke pastu dalam mysql, import je. rasanya bleh kot convert tu.aku xpenah try lagi.

BorderManager

kalau nak convert Access to MySQL guna MySQL Administrator Tools => Migration Tools, kena install JRE dulu

pengodam

Here is how to create an ODBC connection to a MS Access Database:

    1.Open the Administrative Tools icon in your Control Panel.
    2.Double-click on the Data Sources (ODBC) icon inside.
    3.Choose the System DSN tab.
    4.Click on Add in the System DSN tab.
    5.Select the Microsoft Access Driver. Click Finish.
    6.In the next screen, click Select to locate the database.
    7Give the database a Data Source Name (DSN).
    Click OK.

Ref : http://www.w3schools.com/PHP/php_db_odbc.asp

Kalau aku, guna mysql. mudah... ringkas..power