how to use MS access databse

Anon

how can I use a database access with PHP pages? which commands shall I use to connect to that database and which to make the query?

thanx to all

andriy

You can read quite nice book at
http://www.civic.org.ua/mysql/php+mysql.zip

or read documentation at
http://www.php.net/manual/en/ref.mysql.php

God bless you.

andriy

Here is online documentation:
http://www.php.net/manual/en/ref.mssql.php

Hope that it will help you.

Anon

without using mysql?

Anon

ok, it can be useful, thanx, but my problem is different:

I have 2 web servers: 1 linux and 1 NT4.
I have a site divided in 2 parts: public on NT4 made with ColdFusion, private to be rebuild with PHP. The database was made with MS Access 97 and is resident on NT4 server. How can I connect a PHP page (on linux server) to that database to make query on it?

I hope you can understand

thank you again,
Luca

Anon

Luca,

The only way to go about it is to use ODBC drivers. (Open Database Connectivity Layer). Andrew suggested using MS-SQL functions, but it will not work for access.

Use ODBC - it should work,

http://www.php.net/manual/en/ref.odbc.php

Dmitriy