Peter J. Boettcher — Fri, 12 Jul 2002 13:14:18 +0000

Just use Windows Explorer to navigate to the folder that the database is in, do a right-click on the folder and select properties, then click the Security tab and see what accounts have permission on that folder.

joyce — Fri, 12 Jul 2002 02:17:21 +0000

Quote:
Check to make sure the directory your database is in has read/write access for the IUSR & IWAM accounts.

how to check tat? how to change it to write access??

ok, even it's in read access, if i recreate the whole database in xp, i still got the error..

and its already in a folder..

Peter J. Boettcher — Thu, 11 Jul 2002 12:27:46 +0000

Sounds to me like the security settings in XP are tighter. Check to make sure the directory your database is in has read/write access for the IUSR & IWAM accounts. If that fails try throwing the database inside a folder in your website (unless it is already!)

joyce — Thu, 11 Jul 2002 03:42:35 +0000

well, when i test this system using windows98, php4.0.6 and access 2000, everything works fine.

but when i used windows xp professional, php4.1.2 and access xp, i got this error and data are not inserted into the table.

i tried to recreate the database in accessxp but still getting the same error.

i dun think is my query's problem cos everything works fine when i tested in windows 98.

nike_guy_man — Wed, 10 Jul 2002 06:20:46 +0000

That is line 8 of shared.inc?

I'm not familiar with ODBC... what happens when you take that line out?
is it necessary to have it in there?

Mark Hensler — Wed, 10 Jul 2002 06:20:35 +0000

What query was run just prior to that?

joyce — Wed, 10 Jul 2002 05:16:45 +0000

just trying to insert data into database.

line 8

<?php
odbc_errormsg();
?>

nike_guy_man — Wed, 10 Jul 2002 03:21:17 +0000

What is the query and what data is in that row?
What are you trying to do?