Want to update a MSaccessDB locally via

[Anon]

Hello.
I am trying to teach myself how to use a database previously made on MS-Access
and to update it locally on my computer through a php form.
I have installed ApacheWin32, Php4, MySQL, MyODBC and Perl on my Win98 system.
Apache, Php and Perl work fine, but when it comes to database administration,
I can't figure out how to make it work together.
I found manuals and readme files totally ununderstandable.

Someone would be kind enough to give me some useful information
or a step-by-step explanation?
Thanks a lot.

From Sleidia.

[Anon]

I want to do the same

Once i saw the script we are looking for
but i forgot

if you have found the source code to cnonect
to a msaccess database

please tell me where i can get it

thanks

[Anon]

Look to the PHP man, \"XLIX. Unified ODBC functions\".

Need step-by-step explanation?
Here i could write just this:

Step1:
Open Start->Settings->Control Panel->ODBC sources

Step1.1:
Add an user-defined DSN (of course, AccessXX type) - if only you want to access your database

(or smth like this, coz i have russian Win98 installed, it`s a trouble to translate all this)

Step1.2:
read the part of PHP manual about ODBC functions

Step1.3:
Connect to your Access database from PHP script.

Step1.4:
Enjoy :)

Write to my e-mail with any questions

[Anon]

Thanks Dennis, I will try that.
Have a nice day.

[Anon]

// connect to MS Access DB like this
$connection =
odbc_connect("DSN", "usr_name", "passwd");

// DSN is the data source name you create which represent the database name you want to connect to.

// put your sql statement in a string
$sqlStmt = "update tablename....."

// execute the statement
$result = odbc_exec($connection, $sqlStmt)

that should do it.