Can this be done?

tgilbert

I want to allow users to modify data in an network Access database
using a web page on my web server. This is what I have so far

A. Web Connection
I have a W2K Server running Apache.
I have a fixed IP and I have the ports setup so I can access
from the web, the starting page in Apache. So I know that outside
web users can connect to my web server.

B. MySQL
I have also installed MySQL and PHP. Both Apache and MySQL are
running as services. I can (from a dos prompt from the W2K Server)
run mysql (no user or password so far) and it comes up. I can create
and edit tables. So I think MySQL is setup correctly.

C. PHP
I can run through the web site a simple "Hello World" PHP script
So I think PHP is working.

Can mySQL be setup to access and change a network Access database.
I have downloaded myODBC.

I would like to eventually use PHP to allow users to access and
change data in the Access database linked to MySQL using a web page
running on my Apache Web Server.

Can this be done? Am I on the right track?
TIA-TOMG

_SuperString

Na, I dont think MySQL can connect to other Databases on its own (as far as im aware). You need to use PHP to connect to the Databases.

crisward

You seem a bit confused

The php page accesses the database. It does this my setting up a connection and the running an SQL query directly to the access file. You don't need Mysql in this at all.

Mysql is just another database like MS Access.

If I were you I would look up some tutorials on accessing Access via odbc. Then I am sure thing will become much clearer.

Cris.

greg252

If you have mySQL installed, use that. MS says that Access is not made for network DB applications. It works good for RAD and a front-end, but not as a dedicated DB server.

go to the mysql site (www.mysql.com) and read up.

Very powerful, fast and easy (with PHP).

Good luck

levi_501_dehaan

go here to learn about php and mysql. that will solve one problem.

www.mysql.com/articles/ddws/1.html

the next problem is, you can setup access to your access database from php using odbc, i wont ask why you would want to do such a thing, but whatever floats your boat.

but i would suggest learning more about php, mysql, and odbc before taking on such a project if it has a deadline ect, because it will probably take you a while, i would suggest starting with the above tutorial, learning php and mysql, then reading the whole www.php.net. 🙂 the only reason i say this is because there is no reason not to know as much as you can about php 🙂.
the rest is just tags.
-=Lev=-