Before commencing this tutorial, i have to say that for the ODBC setup section,
I used the work
of Leo West. His
page
on ODBC setup and interfacing with Ms-SQL server was most usefull to my original work project...
Until my boss changed the project specs to make the database to be MS-Access, instead of MySQL.
If you need to find out more information about SQL, go
here.
I am going to assume a *little* experience in databases. Having said that, I'm
really only hoping that you know how to create a database and insert tables
into that database.
I have given directions on exactly how to make the above files. But just in case
my directions aren't 100% correct, you can download a working copy of the relevant
software.
Throughout this tutorial, i have assumed that the person who will interface with
the database will have full read and write priveleges to the database. It is best
in any circumstance to make sure you have read and write priveleges to the
database. Having said that, please, please, please try out these techniques on a
sample database located on a 'local' machine. I know first hand the trouble caused
if you screw up a company database upon which most of the company relies.
So, it's onto the tutorial.
| Comments: |
| Nice article on Php and Access | http://www.siebelintegration.com/tutorials | 05/13/09 06:03 |
| PHP with Access | imran khan | 02/28/08 02:25 |
| RE: Connecting my PHP to the Access Database | shanker pokhrel | 08/15/07 06:50 |
| RE: HTTP Error 405 | GOPI | 11/04/05 01:47 |
| RE: Definitive HowTo for Linux | Ralph Quarles | 10/16/05 11:17 |
| RE: Connecting my PHP to the Access Database | kaaria | 07/22/05 09:20 |
| problem in uploading mysql table | Sumanth | 06/22/05 02:46 |
| RE: loading a record from access for an updat | Kiran | 06/12/05 15:19 |
| limit display | handi | 05/22/05 06:13 |
| It's work | faiz | 05/08/05 05:15 |
| importing excel to mysql in linux | Narendra | 04/28/05 07:09 |
| RE: Date / Time Problems | Dina | 04/28/05 07:01 |
| RE: Database_Entries | sagheer | 04/27/05 06:53 |
| data error please help !!!!!!!!!!!!!!!!!!!! | matthew | 04/06/05 11:21 |
| RE: Insert Data into linked table | meesam raza | 03/29/05 16:38 |
| Connecting my PHP to the Access Database | Basheer | 03/27/05 08:22 |
| PHP - ODBC Connectivity... | Prashant | 01/28/05 00:38 |
| Date / Time Problems | Morris Logan | 12/05/04 16:19 |
| RE: Phpmysql conncet doubt | sudheer | 11/13/04 07:21 |
| RE: Access database in Win2000 | shirley | 03/18/04 14:16 |
| RE: SQL error , SQL state 07001 | John | 01/22/04 22:37 |
| RE: How to create Grid in MS Access | dax | 10/30/03 00:44 |
| PHP to MS Access | Sid | 10/15/03 17:15 |
| SUMMARY of solutions 2 basic trbl in tutoria | Andrew Gearhart | 10/05/03 20:06 |
| Definitive HowTo for Linux | John Jonas | 09/15/03 13:06 |
| please give me sample of database | agus | 03/17/03 16:15 |
| ODBC Access 97 - basic ODBC | Christopher Koniges | 01/01/03 17:55 |
| RE: Error, help fix please | Roland | 11/07/02 02:45 |
| Error, help fix please | Adam Borsi | 11/03/02 16:22 |
| SQL problem in ms access 97 (round???) | KEENsBRAIN | 11/01/02 08:16 |
| RE: ODBC to a remote host | Dennis Stollman | 10/24/02 06:05 |
| RE:dataaccess page | benjamin mwamba katongo AIMIS | 10/14/02 09:11 |
| Writing to ODBC | KIswa | 09/24/02 13:37 |
| RE: Access database in Win2000 | Ian Mellor | 09/20/02 12:18 |
| RE: PHP4/ Displaying records from Database. | Ian Mellor | 09/20/02 12:11 |
| PHP4/ Displaying records from Database. | Ian Mellor | 09/16/02 09:32 |
| RE: Consultant | Abhram | 09/13/02 14:45 |
| Consultant | jim charos | 09/11/02 23:36 |
| RE: DSN-less Connections | Abhram | 09/11/02 15:18 |
| Wrong character with ODBC socket server | hatemler | 08/26/02 02:46 |
| RE: ODBC to a remote host | Marcos | 08/22/02 11:23 |
| ODBC to an Access located network drive. | Marcos | 08/22/02 07:51 |
| RE: How to create Grid in MS Access | monfared | 08/21/02 04:37 |
| Database_Entries | Andrew Entwistle | 08/09/02 10:33 |
| RE: Undefined variable | Andrew Entwistle | 08/09/02 08:56 |
| RE: Undefined variable | Andrew Entwistle | 08/09/02 08:52 |
| date format | pauline | 07/29/02 13:20 |
| DSN-less Connections | Malcolm Davis | 07/26/02 07:39 |
| print a report to adobe in ms access | jeff snider | 07/25/02 10:30 |
| Minor corrections | Bryan Frazar | 07/24/02 18:04 |
| How to Duplicate Table ? | A Gunawan | 07/24/02 15:41 |
| HasData, and #ERROR when subform has nodata?? | Nate | 07/18/02 10:21 |
| RE: Connecting my PHP to the Access Database | Alex Gombe | 07/15/02 06:12 |
| How to create Grid in MS Access | Parashiva Murthy KV | 07/08/02 02:55 |
| Populate province combo box after country | Carmela | 07/04/02 19:24 |
| help for insert command | George Mathew | 07/04/02 00:47 |
| Much easier way - see PHP ShareOffice library | Randy W | 07/03/02 13:02 |
| RE: Undefined variable | Peter | 07/01/02 08:09 |
| please please HELP !! | Tom | 06/25/02 17:32 |
| how i can retrieve file | ranjan | 06/21/02 05:37 |
| THANX MAN! | Teye | 06/21/02 04:40 |
| RE: ODBC to a remote host | Luis Alberto Díaz | 06/18/02 06:28 |
| how to connect ms access databse on linux | sachin kosti,dhaval lade | 06/17/02 08:05 |
| Connect to project in module | Kelvin | 06/12/02 13:05 |
| RE: ms access 97 problem | Vishal Arora | 06/11/02 11:45 |
| "Data source name not found " | D Mahoney | 06/10/02 12:48 |
| RE: creating checkobx problem | aruna | 06/10/02 09:33 |
| RE: Undefined variable | V. V. | 06/05/02 14:40 |
| RE: Complex Request very slow | Lou Popovsky | 06/01/02 23:58 |
| RE: Warning: Sql error, Operation must use an up | Lou Popovsky | 06/01/02 23:47 |
| RE: 1 ODBC connec for all mdb files ? like MySQL | Lou Popovsky | 06/01/02 23:36 |
| Undefined variable | Lieven | 05/29/02 16:32 |
| No data passing. | Andreas Egneus | 05/29/02 07:40 |
| http 405 Error | Rob | 05/23/02 06:51 |
| HELP: Storing calculated values in Access | Anu | 05/22/02 18:27 |
| transfering Access to SQL | marlina | 05/20/02 17:31 |
| Not enough information to connect to this DSN | Klaus | 05/20/02 14:37 |
| PROBLEM: linked table permissions | Richard | 05/18/02 08:15 |
| Which ODBC module to use in PHP4 | Ron Owens | 05/16/02 04:38 |
| RE: ODBC to a remote host | Santi | 05/14/02 11:53 |
| .dll file problem | Prashant | 05/13/02 13:45 |
| Thanx | Luxman | 05/10/02 20:04 |
| RE: 22005? Blank screen? Etc? | Bob Arnold | 05/08/02 16:19 |
| RE: 22005? | Jeff | 05/02/02 17:06 |
| RE: Access and PHP | Jeff | 05/02/02 17:02 |
| ODBC to a remote host | Santi | 05/02/02 11:39 |
| need a help | radji soraya | 04/30/02 08:48 |
| 22005? | Kevin | 04/27/02 22:34 |
| RE: Warning: Sql Error | Eun | 04/26/02 23:59 |
| ms access 97 problem | Parminder Singh | 04/22/02 05:50 |
| RE: Passing VARIBLE values between forms? | Ian Mellor | 04/16/02 09:09 |
| Passing VARIBLE values between forms? | Ian Mellor | 04/15/02 11:08 |
| combo boxes | Jag | 04/10/02 04:57 |
| PHP/Access | Evelyn Currie | 04/02/02 05:08 |
| ODBC Connection to Network Drive | Thomas A. Dunlap | 04/01/02 19:32 |
| THE PORTAIL ODBC+PHP : www.odbcphp.fr.st | HELLO / SECTOR ONE | 04/01/02 04:13 |
| RE: PHP and access. | HELLO / SECTOR ONE | 04/01/02 04:12 |
| what does it mean??? | aja | 03/31/02 20:35 |
| RE: query on date format?? | annadurai | 03/30/02 00:43 |
| Refresh Bug | Sukhjit | 03/29/02 07:19 |
| RE: Warning: Sql error, Operation must use an up | Ongki | 03/27/02 00:32 |
| Date/Time Lock Code for Access 97 Program | Richard Plant | 03/25/02 13:50 |
| RE: No ODBC in Control Panel WinXP? | Angel | 03/21/02 09:49 |
| RE: ms access database example | Charles Robinson | 03/14/02 08:23 |
| RE: 1 ODBC connec for all mdb files ? like MySQL | Charles Robinson | 03/14/02 08:18 |
| RE: ODBC on another server | Charles Robinson | 03/14/02 08:09 |
| RE: PHP and access. | Charles Robinson | 03/14/02 08:02 |
| RE: I have a problem | Charles Robinson | 03/14/02 07:58 |
| RE: PHP and access. | hans | 03/12/02 08:47 |
| Access 97 doesn't work!!!! HELP! | Ina | 03/11/02 07:33 |
| Date / Time data type | Ryan Parasram | 03/11/02 01:22 |
| RE: PHP and access. | oneil | 03/06/02 15:02 |
| RE: I have a problem | Question re: formating display of 'Cnt. Src' | 03/06/02 12:22 |
| error in date() function | Diesel1 | 03/05/02 16:19 |
| accessing msaccess/win98 from linux using php | Pravish | 03/04/02 23:29 |
| Error In Insert Into Statement | Daniel | 03/03/02 14:52 |
| Files used by MS-Access | somah | 03/02/02 07:30 |
| php-access | julio | 02/28/02 16:52 |
| RE: Connecting my PHP to the Access Database | mac-doggie | 02/28/02 02:29 |
| Nice article | Susan | 02/25/02 02:42 |
| ODBC on another server | Sergi Maudet | 02/24/02 10:50 |
| 1 ODBC connec for all mdb files ? like MySQL | Jean-Marc Molina | 02/22/02 11:38 |
| MS Access 97 programming | Long Truong | 02/22/02 05:46 |
| Phpmysql conncet doubt | jayakumar | 02/20/02 04:31 |
| MS access and VB-date formats | divya | 02/20/02 01:45 |
| Connecting my PHP to the Access Database | Carl | 02/19/02 10:11 |
| MSSQL 2000 | Rahim Johnston | 02/16/02 17:52 |
| URL Parameters | Mani | 02/15/02 08:15 |
| RE: No ODBC in Control Panel WinXP? | Doug | 02/14/02 13:36 |
| RE: ms access database example | Nuno | 02/14/02 10:58 |
| No ODBC in Control Panel WinXP? | Leonard | 02/11/02 06:04 |
| input data in sequence | Mhd Thabrez | 02/11/02 04:10 |
| how to insert date/time in a report header | Nick | 02/08/02 14:43 |
| getting OLE's from access with php | aliyildiz | 02/08/02 10:37 |
| RE: Warning: Sql error, Operation must use an up | Andrew | 02/06/02 15:42 |
| interfacing sql with access | Marissa | 02/01/02 22:50 |
| RE: Access and PHP | Claudiu | 01/29/02 15:07 |
| RE: Complex Request very slow | Serge Gregorio | 01/22/02 01:14 |
| transfering text | Aeneas | 01/19/02 05:26 |
| question... | Manuel Luis | 01/18/02 08:32 |
| How to create authentication again access tbl | quixman | 01/03/02 19:51 |
| RE:How to create Setup for MS Access | Jonathan | 12/31/01 19:45 |
| RE: MS Access 2000 | Paul | 12/28/01 18:54 |
| RE: What about Linux and Unix | andrew | 12/27/01 16:53 |
| Odbc very slow | Michel Caramez | 12/24/01 11:22 |
| hello | Tristan | 12/18/01 02:19 |
| RE: MS Access 2000 | Patricio Connon | 12/17/01 14:45 |
| Subtables in Access 97 ? | Amol | 12/17/01 11:24 |
| I have a problem | Ashraf Farag Nashed | 12/15/01 14:46 |
| Complex Request very slow | Michel Caramez | 12/14/01 06:06 |
| How do you do date calculations? | clark | 12/13/01 05:43 |
| INSERT on date format?? | david | 12/10/01 00:01 |
| update php + access | hello / sector one | 12/07/01 17:48 |
| Need help : creating search and updating | Richard Hews | 12/05/01 11:14 |
| connection error | alfred | 12/04/01 07:19 |
| Access database in Win2000 | God Stick | 12/02/01 17:34 |
| How to use combo box in access 2000 | cris friolo | 11/27/01 04:45 |
| PHP to SQL | Michael Krueger | 11/26/01 21:34 |
| RE: trouble | Jay C. | 11/22/01 23:50 |
| what about access 2000 | othman | 11/19/01 07:16 |
| how to retrlve data from access in web page | nidhi gupta | 11/16/01 08:52 |
| RE: What about Linux and Unix | Craig | 11/15/01 20:06 |
| php on solaris to access on nt? | Craig | 11/15/01 20:02 |
| loading a record from access for an update | William Kariakri | 11/13/01 17:21 |
| Distributed database | Jorge Martines | 11/10/01 12:47 |
| Text format storage | Brent | 11/01/01 04:43 |
| msaccess2000 connect &apache | Standalone | 10/25/01 03:21 |
| RE: DSN for a dummie. | Eric Torstenson | 10/24/01 15:26 |
| MySQL ODBC Configuration via Proxy Server | justin flanagan | 10/24/01 08:21 |
| RE: How to search the record of access from PHP | Johnny Ingelbrecht | 10/23/01 04:35 |
| Searching code | Johnny Ingelbrecht | 10/22/01 09:52 |
| How to search the record of access from PHP | beta | 10/16/01 15:29 |
| RE: Date / Time data type | Eric Torstenson | 10/15/01 16:04 |
| RE: ODBC connection problem | Ronald | 10/12/01 06:24 |
| problems importing excel to access | Brian Fruit | 10/03/01 12:16 |
| What if... | Al McGrath | 10/02/01 10:55 |
| php & access | vinit | 09/28/01 13:06 |
| SQL error: ???????????? | Jeff | 09/25/01 10:28 |
| RE: what am I missing? | Michel | 09/20/01 00:46 |
| RE: DSN-Less connection to a .mdb in nt from php | Mr. Happy | 09/17/01 20:50 |
| How MSSQL connect to PHP? | Khishigee | 09/12/01 01:42 |
| RE: Why not MySQL? | Bob Frank | 09/05/01 09:38 |
| RE: Why not MySQL? | Revok Asek | 08/30/01 12:21 |
| DSN for a dummie. | Anton | 08/20/01 16:38 |
| what am I missing? | djmill | 08/17/01 19:11 |
| Access DataBase | Rosalind | 08/17/01 04:59 |
| ms access database example | Bhushan Bedekar | 08/09/01 22:05 |
| Editing help | Frentzen | 08/09/01 04:06 |
| Warning: Sql Error | Junior | 08/08/01 17:34 |
| Warning: Sql error, Operation must use an up | Junior | 08/08/01 17:31 |
| how to delete and update record? | fizlynn | 07/23/01 18:43 |
| RE: Launching MS access 97 program | tshine | 07/23/01 16:30 |
| RE: Remotely quering MYSQL database | Time-Out | 07/18/01 21:44 |
| Fatal Error unsupported ODBC_Connect | Jeroen | 07/18/01 14:13 |
| ODBC connection problem | Jeroen | 07/18/01 14:01 |
| RE: how to delete and update record? | Brian Wick | 07/17/01 10:25 |
| How to browse tables | Wibisono Sastrodiwiryo | 07/14/01 23:31 |
| RE: Error 22005 <=-- What's the solution? | Salman Lone | 07/13/01 07:19 |
| RE: Error 22005 <=-- What's the solution? | Salman Lone | 07/13/01 05:56 |
| Wow!! Great Man..I like this tutor! | Momon | 07/12/01 22:44 |
| calculation with date | man wiszbozy | 07/12/01 04:55 |
| SQL error , SQL state 07001 | sgelinas | 06/21/01 07:21 |
| What about Linux and Unix | CDee | 06/20/01 15:20 |
| Error #1064 | Kris Zani | 06/19/01 01:34 |
| Launching MS access 97 program | Mercy | 06/16/01 09:42 |
| RE: How to create Setup for MS Access | Toyin Ferreira | 06/16/01 09:36 |
| RE: Remotely quering MYSQL database | reema_sa | 06/04/01 05:53 |
| solution to most of your problems | matt | 05/31/01 14:23 |
| Thanks for the great example | Nicholas Stevens | 05/29/01 09:42 |
| error! help! | Lorell Hathcock | 05/07/01 12:55 |
| RE: Access and PHP | QRV | 05/04/01 05:38 |
| All's OK, but .....odbc_connect() arguments! | Mauro Bianchini | 05/03/01 08:08 |
| RE: DSN-Less connection to a .mdb in nt from php | Michael Tacelosky | 04/26/01 20:13 |
| Why not MySQL? | Paxton | 04/23/01 01:14 |
| RE: How to create Setup for MS Access | Patrick | 04/19/01 09:44 |
| Remotely quering MYSQL database | Paul Leverenz | 04/18/01 08:35 |
| Access 97 | Anthony | 04/12/01 13:36 |
| convert timestamp in ms access | Joe Doherty | 04/11/01 09:26 |
| RE: Access and PHP | Wallace Tai | 04/11/01 07:55 |
| Access and PHP | Peter G. Limbuhan | 04/06/01 05:20 |
| HTTP Error 405 | Kit Masengill | 04/05/01 18:08 |
| RE: ODBC connection problem | Leigh | 04/04/01 10:09 |
| How to create Setup for MS Access | Siti | 03/31/01 23:46 |
| error on page | hamid saeed | 03/29/01 04:36 |
| RE: Date / Time data type | George Daouros | 03/28/01 16:48 |
| RE: Error 22005 <=-- What's the solution? | barkley | 03/23/01 06:23 |
| RE: Variable Problem | barkley | 03/23/01 06:06 |
| Error 22005 <=-- What's the solution? | Jonathan Angliss | 03/20/01 03:24 |
| RE: Make query to DB | Richard Hews | 03/18/01 13:15 |
| SOLVED! RE: SQL error: ... SQL state IM002 | Charles | 03/16/01 02:38 |
| SQL error: ... SQL state IM002 | Adam | 03/15/01 12:12 |
| RE: Number of rows | John Pugh | 03/12/01 12:35 |
| RE: DSN-Less connection to a .mdb in nt from php | Giri Raj | 03/06/01 03:17 |
| problems with password | k.p.c. wildervanck | 03/01/01 06:53 |
| Number of rows | Fabrice | 02/28/01 02:07 |
| No Matter What Anyone Else Says, it Does Work | Michael Cook | 02/17/01 11:02 |
| RE: MS Access 2000 | Luke Coe | 02/13/01 18:46 |
| : SQL error: ... SQL state IM001 | Yuriy | 02/13/01 10:09 |
| Develop searh engine | Rakseh setia | 02/11/01 07:59 |
| Well Done! | DanoZ | 02/07/01 18:09 |
| Make query to DB | Richard Hews | 02/06/01 15:45 |
| RE: ODBC connection problem | Kevin | 01/27/01 23:03 |
| Input data is copied twice after input. | John C. | 01/26/01 14:00 |
| odbc-problem | tapani hanninen | 01/16/01 13:27 |
| ODBC connection problem | Eric | 01/16/01 09:56 |
| RE: SQL Error - state 22005 Win2K | Graham Jenkin | 01/13/01 08:09 |
| MYODBC | Ramiro Radjiman | 01/08/01 13:58 |
| SQL Error - state 22005 Win2K | Phillip Oldham | 01/04/01 05:07 |
| Re: MSAccess, remote | Ivan Ossander | 01/02/01 19:00 |
| MS Access, remote | Ivan Ossander | 12/30/00 07:55 |
| DSN-Less connection to a .mdb in nt from php | Galib Anwar | 12/23/00 17:09 |
| microsoft access | laura krupp | 12/22/00 09:34 |
| Formatting dates | Lorraine Howard | 12/18/00 12:04 |
| RE: SQL error - part 2... | Troy | 12/14/00 01:21 |
| SQL error - part 2... | Troy | 12/12/00 23:16 |
| SQL Error - state 22005 | Troy | 12/08/00 23:20 |
| RE: MS Access 2000 | Nick Allen | 11/14/00 20:07 |
| Setting up PHP and Apache | Lars Rundberg | 11/14/00 06:39 |
| RE: MS Access 2000 | Herco van Brug | 11/09/00 07:57 |
| Date / Time data type | Jeff Hall | 11/07/00 11:50 |
| MS Access 2000 | Herco van Brug | 11/07/00 08:24 |
| RE: DSN-Less? | Toby J Boyd | 10/30/00 15:42 |
| RE: Warning: SQL error...... | Brcue van der Kooij | 10/29/00 08:31 |
| Warning: SQL error...... | Bruce van der Kooij | 10/28/00 15:11 |
| ODBC module in PHP | Gerald Meunier | 09/29/00 03:59 |
| RE: SQL Error | Brian | 09/27/00 12:15 |
| SQL Error | Brian | 09/25/00 15:36 |
| RE: Error on update query with ODBC/Access97 | Mike Fast | 09/19/00 21:24 |
| Error on update query with ODBC/Access97 | Phil Beaushilom | 09/19/00 05:58 |
| Re: how to delete and update record? | Mike Fast | 09/15/00 22:46 |
| how to delete and update record? | Cheah Kok Wengq | 09/14/00 14:24 |
| DSN-Less | Scott Anderson | 08/23/00 14:22 |
| RE: DSN-Less? | Mukul Sabharwal | 08/22/00 12:03 |
| RE: Variable Problem | Mike Fast | 08/12/00 13:17 |
| RE: Variable Problem | Clarence Liau | 08/12/00 10:16 |
| RE: query on date format?? | Josh Bowers | 08/03/00 19:13 |
| query on date format?? | Niels | 08/01/00 06:55 |
| Variable Problem | Paul Malkowski | 07/24/00 04:12 |
| RE: trouble | Jim Hawley | 07/11/00 12:15 |
| fields don't exist | Aaron Prohaska | 07/09/00 01:25 |
| DSN-Less? | Dennis Williams | 06/30/00 13:51 |
| trouble | Jason Gelman | 06/29/00 20:02 |
|
If you are looking for help, please post on the appropriate forum here. Your questions will be answered much more quickly.
|
