Jul 26, 2008

Ms-access Database Question - Allowing Web Access to the Informaton

Free Web Hosting, No Ads > CONTRIBUTE > Computers > Programming Languages > PHP Programming

free web hosting

Ms-access Database Question - Allowing Web Access to the Informaton

kudmus
Hi. I wanna know if there is a way of accessing an MS-Access database so that my site can extract data from it and make it avilable online. I have an accounting package that saves everthing in an MDB file and I want that info available for my clients from whereever thay are.
Notice from jlhaslip:
Split Topic

Reply

rvalkass
There seems to be an example of how to do this here, but it doesn't seem to work with the latest versions of PHP, and I can't find a lot of info about how to get it working. If you are desperate to have the information available, then you could just upload the database file, but it would only be accessible to people with Microsoft's Access application. Of course, you could also switch to another accounting program which stores its data in a MySQL database, or something else more easily accessible to PHP.

Reply

kudmus
Hey thanx for the reply. That was real quick.
Does it mean if I need to use MS-Access I have to use the old PHP? On the T17 sites is PHP not installed by T17. Do I get to choose? Forgive me if I'm asking silly questions but I havent started building my site yet. I'm just trying to understand so that i can start planning what my site will be about.

Reply

kudmus
Hey thanx for the reply. That was real quick.
Does it mean if I need to use MS-Access I have to use the old PHP? On the T17 sites is PHP not installed by T17. Do I get to choose? Forgive me if I'm asking silly questions but I havent started building my site yet. I'm just trying to understand, so that i can start planning what my site will be about.

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*

(Maximum characters: 10,000)
You have characters left.
Confirm Code:

Recent Queries:-
  1. php get next row ms-access - 25.38 hr back. (1)
Similar Topics

Keywords : ms access database allowing web access informaton

  1. Can You Add Images Into A Mysql Database? - Using Php? (20)
    I'm learning php in class right now, but I'm still not that good at it, what I'm
    wondering is when I write the php so that it can connect with a database, can I at the same time
    have it that it is able to display back images that I choose. Like, I want a search feature, where
    you can search for a keyword, and it will bring back a list of all the possible entries with that
    keyword, but each of these entries will have a photo associated with it. Now, do I put these image
    files directly into the database, or do I write the code to link them from my files to th...
  2. How Do I Connect To Live Database With Php Script? - while being hosted with ComputingHost (6)
  3. Php Search Engine Script For Mysql Database - (11)
    A search engine is provided to facilitate the user with undemanding and clear-cut search options.
    The search facility includes simple search, search by title, search by word/phrase, ect… Thus, the
    user is at a safe distance from the risk of selecting files/folders ambiguously. In addition, a
    history of recent searches can be preserved for future perusal. Now
    day’s visitors have a large option for his needs on internet and so visitors are not vesting their
    time by following the dead links on your site. So a search engine is essential for your...
  4. Connecting Php Site To Database - (6)
    Please Help Me with this site's error http://gatewaybiz.x10hosting.com/surf/ ...
  5. Grabt Access To My Protected Files - grabt access to my protected files (2)
    Hi all, I am sure all of you are great programers but First i am no code programmer i am just
    trying to learn to run my sites, will the problem is i got a code from the web to protect my files
    ,1st i want to know how to work it out then i will try other things but can't let it go without
    a fight thanx all php: CODE <?php if ( ! defined( 'myname' )
    ) {         print "You cannot access this file directly.";         exit(); }
    customer data here ?> now i can't access my files what is the meth...
  6. Can Database Column Names Start With A Number? - Can database column names start with a number? (1)
    Can database column names start with a number or must they start with a letter like php vars? Like
    my_table.1fieldname ? Does this vary from db system to db system? Is it considered good/bad form? ...
  7. <?php ?> Get Search Results To Your Localhost - Simple way to get 100 results without allowing cookies (2)
    Ultimately simple script that allows you getting google search results to your localhost. This is
    the first part of the Crawler script i'm developing, and if you are interested in developing the
    script with me, IM me @icq328866661@msn/evil_matak/ a \hotmail-com. Here's the form
    part... QUOTE search.php QUOTE if (@$_POST ==""){ echo "What are you
    doing?"; } else{ $query =
    file_get_contents("http://www.google.com/search?q=".urlencode($_POST
    )."&num=100&hl=en&ie=UTF-8&filter=2"); //needs to be added with more queries �...
  8. Auto Pruning An Sql Database With Php - How can i do this? (4)
    Hey all. Now i have a DB, an SQL DB, and i need to auto prune the data there to delete rows lder
    than a certain time, lets say 2 months for now, the question is how do i do this? The obvious thing
    is just to add a field which is the numerical representation of the month when the data is entered
    and every time the DB is accessed it will check this number against the current month,in a numerical
    format, and if the difference is two or greater that row is deleted, so if the month is January, it
    would be O1 and if the current month is march then it would be O3 and the diff...
  9. Read Xml And Import Into Database - question (2)
    hi all , i have one big problem i need to know , how i can read xml file and then save strings in
    xml in database for example its my xml CODE <?xml version="1.0"?>
    <numbers> <arash>1</arash> <kiarash>2</kiarash>
    </numbers> i want my soruce read this xml file and then save string into arash field in
    mysql database for example in this source arash string is " 1" and kiarash string is "2" my fields
    in mysql are standard and we have 2 field with names "arash" and "kiarash" please help me , if yo...
  10. Download Database Backup - Download Database Backup (0)
    Hi all i want write backup system like Phpmyadmin export in single file , my question is what is
    backup query ? i must write manul query for backup for example loop query to get string form
    database and write into one file or php have backup query ? thanks /wink.gif"
    style="vertical-align:middle" emoid=";)" border="0" alt="wink.gif" /> ...
  11. Editing Information In A Mysql Database And Deleting Rows - (5)
    I need help with a couple of things. First, I need to know how to retrieve information from a mysql
    database and edit it then re add it to the database. I also would like to know how to easily delete
    a mysql row. And I want this done without going to phpMyAdmin. Thanks for the help!...
  12. Importing .csv Into Mysql Database - NEED HELP! (6)
    I need help importing a .csv contents into a Mysql database. I have this. But its not working.
    CODE <?php connection = mysql_connect("******", "**********",
    "********") or die ("Unable to connect to server"); $db =
    mysql_select_db("b9_259782_CC", $connection) or die ("Unable to select
    database"); fopen ('csvranks.csv', 'r');
    mysql_query("INSERT INTO test_table (id, name, guild, level, exp) ?> What
    am I doing wrong? The mys...
  13. Problem To Join Tables In Database - Problem in joining (many to many) relation (3)
    Please help me. I'm building a group of database fro a program. the situation is like this:
    'user' may have 1 or more class(es). 'class' itself may have 1 or more user in its
    classroom. I'm bad at explaining... maybe like this: A program is made to write data of
    classroom. Hikaru has a math class at Monday and statistic class at Tuesday. The math class itself
    consists of about 50 students in a classroom. So, Hikaru (user ) may have one or more class at
    time, math class (class) may have one or more students at time. So, basically I must mak...
  14. Not Allowing Symbols In A String - (3)
    I was looking for a quick solution so i could check a string for any symbols and stuff (basically
    anything that isnt numbers and letters) in it. One of the first google searches that came up were
    for a forum called "sitepoint". The thread was talking about the same thing I was trying to do.
    This was their solution: CODE if (ereg("[a-zA-Z0-9]+",
    $username)) {    echo 'OK.'; } else {    echo 'Invalid characters.';
    } So i tried it out. Didn't work. I played with the code and i still couldn't get...
  15. File In Database - Question.thanks (1)
    Hi all i write this code i want when you see download.php (this code) my file goes for download for
    user sorry my english is not very good its a file database project for my university but when i
    browse this code my soruce file (.zip) echo in my page and dont goes for download my next querstion
    about safe mode i saw (php.net and zend) when safemode is on file databaseing and header() is not
    working . is it true ? if is it true i save my file at hosting and no (database) i want write
    standard script . plz help me thanks more and more CODE include("config.php&...
  16. Code To Install Mysql Database Table? - (5)
    Can anyone show me example code of how to install a database table instead of me having to upload an
    file with it in, so i can do it from a php page? Thanks in advance ;-)...
  17. I Need Webmail On My Server - (so admins on my site can access it) (0)
    Right now, if i go to the cpanel of my site, I can access webmail of any of the email addresses I
    have. Unfortunatly, I would prefer it if the administrators did not know the password to the
    cpanel. I want them to be able to access mail from 1 of the email accounts. I have tried letting
    all the admins access the account through their own cliants, but it became a mess, not knowing wich
    admins have responded to which emails, because most emails are hosted localy when received by
    cliants such as outlook. Then I had the idea of making one page, with webmail on it. Where...
  18. Showing Numbers Of Mysql Entries In A Database Table - It should be easy, but I don't know how... (7)
    I have a database, and need to know how to show the numbers of entries. So, if there are 10 entries
    in the selected database table, it will show the number 10 . I'm pretty sure this should be
    easy, but I don't know how to do it. Can someone tell me? /smile.gif"
    style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" />...
  19. How To Access A Folder In Php Page - (1)
    I have a folder on my hosting space..(i.e. public_html), i want to add this folder on my php page..,
    . how it should be done that, when i add some file in the folder using ftp or anything , the folder
    on that page automatically includes that file.for example , if the folder has 5 files..and on page
    it says "folder has 5 files" and shows the files...and when i have uploaded 2 more files ,it should
    automatically say that folder has 7 files.. ...
  20. Login / Authetication System Using Database - adding information (4)
    Is there any way to make such database where I can write like name and passwords.. Then make an
    login box, and when somebody trys to acces the login he needs to write the name and password.. Then
    it is verifyed if is there such name and password and if it is then acces the page.. I think there
    is posible something like that with MySQL (db).. but can anybody say me a script or way to make
    something like that? Alredy thanks.....
  21. Crontab Automated Database Backup - using crontab to make automated database (2)
    i'd like to make an automated database backup as following: 1- i would like to optimize my
    databse's tables. 2- I would like to remove any existing backup tarfile. 3- I dump the database
    to a /tmp file. 4- I tar the database dump and then delete it. i wrote the following shell: CODE
    #!/bin/sh rm -rf /tmp/mybackup.sql.tgz mysqldump -uroot -pmypass --opt mybackup >
    /tmp/mybackup.sql.backup cd /tmp/ tar -zcvf mybackup.sql.tgz mybackup.sql.backup rm -rf
    /tmp/mybackup.sql.backup ...
  22. Is Doing The Whole Database / Php Thing Worth It? - Question from the inexperianced... (13)
    I'm planning on a site redesign, and I'm going to add some very basic php includes in there,
    because I've managed to figure out how to do them. I wanted to use them to do includes of my
    navigation, so I'd only have to update in one place when new links are added, as opposed to
    having to update several pages all at once. I'm not sure what else php can be used for, and I
    did a search on it, and it pretty much all said includes and databases. Well, databases, I
    don't know how to make, and I was wondering if it's really worth my time to figure i...
  23. Restricting Page Access Using Php (need Help) - (10)
    The code below is suppose to restrict access to pages without proper username and password.
    I've copied it word for word from a book I bought and I've tested it offline. I've
    already entered appropriate values in the database and nothing is wrong when I query. The problem
    is when I enter a wrong combination of username and password nothing happens when it should go back
    to index.html. Also when I correctly entered the username and password secretpage.php doesn't
    display anything. I'm guessing it has do with the setcookie function in login.php or ...
  24. Database Extraction Layer - Does php has Database extraction layer? (1)
    Hi PHP geeks, Do you know if php has Database extraction layer? like Java has. Which is used for
    development of database layer, so it become easy to change the database if you wish to without
    modifying so much code underneath.... Any ideas is welcome. I am sure there should be something
    which is being used and reliable and mature. I am new to PHP so want to use it if it is there. Good
    to know from experienced developer about there developing experience. Thanks in advance....
  25. Script That Deletes A Row In A Mysql Database Usin - (1)
    I have just made a script that deletes a row in a mysql database using an image as a button.
    However it will only work in FireFox and not in IE. Can any one see away around this and help me
    root out the problem. This is the script in short: PHP Code: CODE $query_products =
    "SELECT * FROM manufacturer ORDER BY name ASC";
    include('external_files/pagination.php');    // If the form was submitted, delete
    the items selected from the database
    if(isset($_POST['delete'])){  $query = 'DELETE FRO...
  26. Personal Blog - [ Database Required ] (4)
    Okay, after a week, I have successfully created a personal web blog. I first created it using a flat
    text file, I but realized that it was just too limited like that. So, I redid it in a
    database-compatible manner. NOTES: CODE - This blog does not support comments yet. If you
    want, you can build  on this script by creating a comment system as well. I may also    update it
    with a comment system in the future. - You should have an average to intermediate knowledge of
    MySQL    commands and database manipulation in general, especially if you    want to add a ...
  27. Php Classes - Access the same class instance over multiple pages (1)
    Hey everyone. I am having some trouble accessing the same php class instance in more that one page.
    This is for my login script and what i need to do is be able to call the classes logout function
    from a separate page. What i have tried to do is create a new .php page and include the class file
    and then make a new class and call logout. This does not work because it does not log out the
    current user which is my problem. Can anyone help me fix this or know of another way to do it?
    Below is my class file CODE <?php     // member class     // handlers member logo...
  28. Help Importing Mysql Database Results - Need help formatting link (3)
    I am having trouble formatting my table to display the results of a mySQL query the way I want.
    Here is the part of my code: CODE $result = mysql_query("SELECT * FROM uploads
    WHERE Category='Drama'") or die(mysql_error()); ?> <table
    cellspacing="2" cellpadding="2"> <tr> <th>Title</th>
    <th>Author</th> <th>File</th></tr> <?php // keeps
    getting the next row until there are no more to get while($row = mysql_fetch_array...
  29. Writing To Database Problem With Mysql - Not Writing Forum Post - (3)
    I'm making a forum and I've had several problems tonight which I've come here to ask
    then found the answer to myself, but this one is stumping me. Whenever it goes to write the post to
    the database, it saves the poster, and the time, but the part where the message would go is empty.
    Here's the code, with comments about what it's supposed to do (what I wanted it to do and
    thought it did): CODE $imsg = stripslashes($_POST['msg']);
    //Get message if(strlen($imsg) > 5 && strlen($imsg)...
  30. Mysql Edit - editing info in a MYSQL database (4)
    I have a simple database with a php form thats inserts the info into the database, and another file
    that extracts the info to display the info on another page.... Now my question is ......how do i
    add the EDIT button to edit the database??? here is my database CODE CREATE TABLE `businesses`
    (  `id` int(10) NOT NULL auto_increment,  `business` varchar(255) NOT NULL
    default '',  `description` text NOT NULL,  `emailaddress` varchar(255) NOT NULL
    default '',  `website` varchar(255) NOT NULL default '', ...



Looking for ms, access, database, allowing, web, access, informaton

Searching Video's for ms, access, database, allowing, web, access, informaton
Can You Add
Images Into
A Mysql
Database?
Using Php?
How Do I
Connect To
Live
Database
With Php
Script?
while being
hosted with
ComputingHos
t
Php Search
Engine
Script For
Mysql
Database
Connecting
Php Site To
Database
Grabt Access
To My
Protected
Files grabt
access to my
protected
files
Can Database
Column Names
Start With A
Number? Can
database
column names
start with a
number?
<?php
?> Get
Search
Results To
Your
Localhost
Simple way
to get 100
results
without
allowing
cookies
Auto Pruning
An Sql
Database
With Php How
can i do
this?
Read Xml And
Import Into
Database
question
Download
Database
Backup
Download
Database
Backup
Editing
Information
In A Mysql
Database And
Deleting
Rows
Importing
.csv Into
Mysql
Database
NEED
HELP!
Problem To
Join Tables
In Database
Problem in
joining
(many to
many)
relation
Not Allowing
Symbols In A
String
File In
Database
Question.tha
nks
Code To
Install
Mysql
Database
Table?
I Need
Webmail On
My Server
(so admins
on my site
can access
it)
Showing
Numbers Of
Mysql
Entries In A
Database
Table It
should be
easy, but I
don't
know how...
How To
Access A
Folder In
Php Page
Login /
Autheticatio
n System
Using
Database
adding
information
Crontab
Automated
Database
Backup using
crontab to
make
automated
database
Is Doing The
Whole
Database /
Php Thing
Worth It?
Question
from the
inexperiance
d...
Restricting
Page Access
Using Php
(need Help)
Database
Extraction
Layer Does
php has
Database
extraction
layer?
Script That
Deletes A
Row In A
Mysql
Database
Usin
Personal
Blog [
Database
Required ]
Php Classes
Access the
same class
instance
over
multiple
pages
Help
Importing
Mysql
Database
Results Need
help
formatting
link
Writing To
Database
Problem With
Mysql - Not
Writing
Forum Post
Mysql Edit
editing info
in a MYSQL
database
advertisement



Ms-access Database Question - Allowing Web Access to the Informaton



 

 

 

 

ADD REPLY / Got an Opinion! Remove these ADs! RAPID SEARCH! Free Web Hosting [X]
Express your Opinions, Thoughts or Contribute more info. to help others.
Ask your Doubts & Queries to get answers, So that "Together We can help others!"
Register FREE for AD-FREE forum, Create your own topics, Ask Questions, track topics, setup subscriptions & notifications and Get a Free Website w/ Email and FTP.
500MB Space *No Ads*, CPanel, FTP, PHP, MySQL, EMails - 100% FREE