PHP With MS-Access
free web hosting
Free Web Hosting > Computers & Tech > Databases

PHP With MS-Access

haitamlong
Oct 4 2006, 10:37 AM
Hi am a newbie here. Can i ask how to connect php with ms access data? They now offer so less mysql data base. Im trying to convert my web to use access. Is it as secure as mysql huh.gif

Reply

mastercomputers
Oct 4 2006, 11:23 PM
Hey haitamlong,

MS Access is quite slow in my opinion and is not really in the league to compare to MySQL when it comes to the web. It would be better if you compared MSSQL to MySQL. However there are some things you should know, if you're developing software for desktop use in a Windows environment then either use a very light database like SQLite because of it's size or MS Access because it's file based, there are also others out there (I prefer SQLite). MySQL is not easily distributable and not suitable for desktop because it has to be installed and it's not small enough for ordinary users. However depending on the size of data you'll be expecting, then maybe a more scalable and larger database should be considered.

To use PHP with Access, you use ODBC connection methods.

Here's the PHP Manual section for ODBC: http://php.net/odbc

And here's a few tutorials, the first one is probably more complete but it's about MSSQL but the difference is you'll be using MS Access Driver instead.

http://www.zend.com/zend/tut/odbc.php

And this one is about MS Access:

http://www.w3schools.com/php/php_db_odbc.asp

Cheers,

MC

 

 

 


Reply

Got an Opinion! Express your Views! (no registration):-
Add your Reply/ Opinion/ Views/ Comments/ Suggestion/ Questions/ Queries etc.
Posts with decent grammar & English will be accepted and please refrain from profanities.
For asking a Question, We recommend you to sign-up (for free) so that you can track the topic easily.
Nature of your Post*: Opinion/ Reply/ Comments
Question/Query
Feedback to us.
       
Name   Email
Title/Question*

Recent Queries:-
  1. free access database php tut - 370.99 hr back. (1)
  2. free php tut access database - 374.91 hr back. (1)
  3. php to ms access - 397.39 hr back. (1)
  4. free web php with ms access databse - 397.80 hr back. (1)
  5. connecting php to access database - 460.47 hr back. (1)
  6. query in ms access using php - 475.54 hr back. (1)
  7. form to msaccess php - 486.25 hr back. (1)
  8. connect to access db using php - 492.70 hr back. (1)
  9. connect to access database with php - 503.95 hr back. (1)
  10. php ms access - 508.89 hr back. (2)
  11. php and ms access - 521.33 hr back. (1)
  12. ms access and php - 530.84 hr back. (1)
  13. php access database login - 580.32 hr back. (1)
Similar Topics

Keywords : php, msaccess

  1. Database Access On Remote Server W/jsp
    (0)
  2. Accessing Ms Access Database From A Centralized Location?
    (5)
    Hi I am a manager at a trading/wholesaling company (and have no programming background). I
    customized the Northwind sample access database to make invoices and keep accounts for my company.
    We now opening another office at a distant location. So, the order entry will be done at two
    points(we plan to use the same Access database). I am not able to figure out how to access the same
    MS Access database from two different location(as LAN can't be used). Moreover, we can't
    afford to pay huge sums to the software developers. Can intranet or uploading the database t....
  3. Integrate Access Database Onto Intranet Site
    Looking to integrate access database into my intranet site (5)
    Hey guys, im new here and am looking for answers /tongue.gif" style="vertical-align:middle"
    emoid=":P" border="0" alt="tongue.gif" /> Firstly, i have designed a database using M$ access, it
    consists of multiple forms which i plan to host on an intranet website, i need to be able to add
    records directly from the form on the intranet website aswell as being able to edit/review current
    entries on forms in the database. My question is, how would i go about integrating these forms onto
    the intranet website? i plan on keeping the database and the intranet site on the same d....
  4. Access 97 To Access 2003
    (15)
    I need to convert a database that is in Access 97 to Access 2003 but every time i do it using the
    Convert tools of Access 2003 i got some errors and can't change or add any of the objects
    -tables, querys, etc- of the converted database. All the errors i got are related to the user
    priviligies and permissions of the database, is there exists a way or procedure that allows me to
    reset this permissions??? Best regards,....
  5. Access
    Is this easy to make a login/password? (17)
    I was looking to make a site where people need to create an account, and log in to view the main
    pages. Is it easy, or do-able, to use msoft access to make a database where people are able to sign
    up with a username and password via my website?....
  6. Public Access Oracle Db?
    (5)
    This may be the stupidest question ever, I don't know, but frankly if this exists it would help
    me out a lot haha. What I'm looking for is an oracle database set up somewhere that has an open
    uname/password for the public to use for testing or anything really. I'm just developing
    something that needs to connect to our oracle db here but we don't want the computers to be
    required to have the oracle client installed. Currently though all the computers I have access to
    here DO have it installed and need it to stay for the time being, and I can't access o....
  7. MS Access Validation Rule
    Desperate help needed (2)
    I have to create a whole project using Microfost Access. I have a field which will eventaually
    contain details of a a list of people's DOBs. I have added an input mask, so that it it displays
    the place holder __/__/____ However, how can I validate this field. For example, not it is possible
    to type 30/10/1991 . How can this be changed so that it validates it correctly?....
  8. Access -> Mysql
    Converter (8)
    I have a problem. Is any program wchich converts database Access to Mysql ??....
  9. Read/Write Issues After Copying An Access .mdb File
    (3)
    Alright, I'm currently creating an interface program for a MS Access database. I've only
    used Access once in the past but used other DB's a handful of times so I didn't have any
    trouble getting the general program created. My issue arose when I tried to make it so that the
    users needing to use the program can just copy the .exe and the .mdb files and use it. The program
    doesn't require users to share the database but to store their OWN programs information in their
    OWN database, so basically each needs to have their own database with the exact same d....
  10. MS Access DB To Webpage Connection ?
    (5)
    ok .. i have this little problem i am going through ... Leme explain this project of mine first . I
    have a MS Access DB of student fields like ID no, Name, Marks .. etc .. This one Access DB would be
    updated by just adding more rows and would be done on the server. It looks sumthing like this:
    Now .. I have a HTML page that shows this : I would enter the ID number of a student (no
    authentication .. anyone can access anybodys marks), and when i hit submit .. I would be taken to a
    page that gets the values from the ID specified and shows it in the next page. The pa....
  11. Help With Registration Page, Access Denied.
    (10)
    I'm coming up with an error that I can't figure out in my registration page. Below I've
    given the error message and the code. QUOTE Warning: mysql_connect(): Access denied for user:
    'nobody@localhost' (Using password: NO) in /home/lonebyrd/public_html/db_connect.php on line
    33 Access denied for user: 'nobody@localhost' (Using password: NO) CODE $Host =
    "localhost"; // define host name (default: localhost) $User = "$lonebyrd_razmo"; // define database
    username $Password = "$****"; // define database password $Database = "$lonebyrd....
  12. Help Me With My MS-Access Program
    (2)
    Hi anyone can help me with making a form. These are the case; I am using Ms. Access XP, and a
    database for using as a admission database for new students. And using couple table for the base,
    however I want that when the operator is trying to add a students (add button), a form will came up,
    and asking for his/her ID and password and Cliking the LOGIN button and lookup for the ID and
    Password which stored in a "user" table on the database. When the ID and Password 're correct
    the function for adding students can be processed, but when the ID and Password uncorrect....
  13. I Have A Question About MySQL Access & Quotas
    (1)
    On my previous web host, I surpassed my MySQL quota limit. At least, that's what they told me.
    The following message is the error I get. phpBB : Critical Error Error creating new session
    DEBUG MODE SQL Error : 1044 Access denied for user: 'darnem_trials@65.98.98.74' to database
    'darnem_trials' INSERT INTO phpbb_sessions (session_id, session_user_id, session_start,
    session_time, session_ip, session_page, session_logged_in) VALUES
    ('7719681862d0a4bfc392929af1357326', 2, 1125023783, 1125023783, '18d160ac', 0, 1)
    Line : 168 File : ....
  14. Logic To Break Down An Access Tabbe To SQL
    what is the easiest way to split this? (1)
    I have 3 differen tables in this database that are basically repeating the same data. How can I
    split it up and still use it. This is the horse project /smile.gif' border='0'
    style='vertical-align:middle' alt='smile.gif' /> the 3 tables are called Horse, Dam, Sire . the
    Horse table should be enough for all the data. (at least that is what I'm thinking) the Dam &
    Sire are used to track lineage and are setup Like this: CODE SireID; Horse; Sire; Dam;
    SireSire; SireDam; DamSire: DamDam; SireSireSire; SireSireDam; SireDamSire; SireDamDam;
    DamSireSire;DamSireDam....
  15. Access
    Lesons (0)
    The HP Learning center offers very good free lessons on creating databases with step by step
    instructions. You can access the learing center at HP Learing Center ....
  16. Access To MySQL Remotely
    (2)
    i am using a software to access to mysql remotely but it display error!(Access denied for
    myusername@my ip address) please help me ....
  17. Is php supports MS Access
    Ms Access Database (7)
    I want to know that is php supports MS Access databases. And could anyone told me the complete php
    installation. I have little bit problem during installation.....
  18. How To Transition The Database
    transition the database to access (2)
    i want to transition the records in SQL7 to ACCESS in the condition of VF 6.0 how i can?....
  19. How To Access a Remote MySQL
    (1)
    I try to access to a remote mysql owned by my friend , I have the IP and username and password. but
    I always got this information: Fatal error: Maximum execution time of 30 seconds exceeded in
    XXXXXXXXXXXXXXXX....
  20. How To Dump .SQL File to MS-Access
    (3)
    Is there any way to convert a mySQL dump (.sql file) to an access file? Problem is, I downloaded and
    installed the mySQL server and ran it. But I couldn't restore the dump - it kept complaining
    about charsets and even the guy who created the dump didn't know what was up. So I'm
    looking for another way to access the contents of the database. Help anyone?....


      21. Looking for php, msaccess






*SIMILAR VIDEOS*
Searching Video's for php, msaccess
Watch the latest videos on YouTube.com
advertisement




PHP With MS-Access