neilhoman
asked on
MSAccessDB not updating
PHP Version 4.0.5
MsAccess 2000.
Connecting to Msaccess through a web page (PHP) via
ODBC connection.
Select queries work fine.
But a simple update query fails.
No error messages ..... the result object == TRUE.
in other words I check to see if the
$Result = odbc_exec($Conn, $stmt);
if ($Result)
{
output error msg etc. never gets executed
}
I am about to head home from work now but I will do my best to keep up with any replies from home.
-thx for you help
-Neil
MsAccess 2000.
Connecting to Msaccess through a web page (PHP) via
ODBC connection.
Select queries work fine.
But a simple update query fails.
No error messages ..... the result object == TRUE.
in other words I check to see if the
$Result = odbc_exec($Conn, $stmt);
if ($Result)
{
output error msg etc. never gets executed
}
I am about to head home from work now but I will do my best to keep up with any replies from home.
-thx for you help
-Neil
ASKER
IUSR_ has full control of the the directory in which it is located.
It is not web shared however... the update simply runs but simply doesnt update the record. Even though the query does not fail.
I have pasted the query into other odbc query tools and the query runs successfully.
This is why I have posted in this forum... I feel it could be more a php/web problem than an access problem.
-neil
It is not web shared however... the update simply runs but simply doesnt update the record. Even though the query does not fail.
I have pasted the query into other odbc query tools and the query runs successfully.
This is why I have posted in this forum... I feel it could be more a php/web problem than an access problem.
-neil
ASKER
when I say an access problem I mean MSaccess...
->
Perhaps there is and ini setting that is feckin it up.
like I say read queries run fine the update query does not fail .... it is almost like the update isnt commiting.
->
Perhaps there is and ini setting that is feckin it up.
like I say read queries run fine the update query does not fail .... it is almost like the update isnt commiting.
It's time to clean up this topic area and that means taking care of this question. Your options at this point are:
1. Award points to the Expert who provided an answer, or who helped you most. Do this by clicking on the "Accept Comment as Answer" button that lies above and to the right of the appropriate expert's name.
2. PAQ the question because the information might be useful to others, but was not useful to you. To use this option, you must state why the question is no longer useful to you, and the experts need to let me know if they feel that you're being unfair.
3. Ask Community Support to help split points between participating experts. Just comment here with details.
4. Delete the question because it is of no value to you or to anyone else. To use this option, you must state why the question is no longer useful to you, and the experts need to let me know if they feel that you're being unfair.
If you elect for option 2, 3 or 4, just post comment with details here and I'll take it from there. We also request that you review any other open questions you might have and update/close them. Display all your question history from your Member Profile to view details.
PLEASE DO NOT AWARD THE POINTS TO ME.
__________________________
Hi Experts:
In the event that the Asker does not respond, I would very much appreciate your opinions as to which Expert ought to receive points (if any) as a result of this question. Likewise, you can also suggest that I PAQ or delete the question.
Experts, please do not add further "answer" information to this question. I will be back in about one week to finalize this question.
Thank you everyone.
Moondancer :)
Community Support Moderator @ Experts Exchange
P.S. REGARDING POINTS, Guidelines and more: https://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp
1. Award points to the Expert who provided an answer, or who helped you most. Do this by clicking on the "Accept Comment as Answer" button that lies above and to the right of the appropriate expert's name.
2. PAQ the question because the information might be useful to others, but was not useful to you. To use this option, you must state why the question is no longer useful to you, and the experts need to let me know if they feel that you're being unfair.
3. Ask Community Support to help split points between participating experts. Just comment here with details.
4. Delete the question because it is of no value to you or to anyone else. To use this option, you must state why the question is no longer useful to you, and the experts need to let me know if they feel that you're being unfair.
If you elect for option 2, 3 or 4, just post comment with details here and I'll take it from there. We also request that you review any other open questions you might have and update/close them. Display all your question history from your Member Profile to view details.
PLEASE DO NOT AWARD THE POINTS TO ME.
__________________________
Hi Experts:
In the event that the Asker does not respond, I would very much appreciate your opinions as to which Expert ought to receive points (if any) as a result of this question. Likewise, you can also suggest that I PAQ or delete the question.
Experts, please do not add further "answer" information to this question. I will be back in about one week to finalize this question.
Thank you everyone.
Moondancer :)
Community Support Moderator @ Experts Exchange
P.S. REGARDING POINTS, Guidelines and more: https://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp
In the attempt to help clean up abandoned Questions, I will ask Community Support to delete this question A.S.A.P.
If any expert feels the points should be awarded you can post a request in Community support (please
include this link)
The link to the Community Support area is: https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
Please do not accept this comment as an answer!
Andriv
If any expert feels the points should be awarded you can post a request in Community support (please
include this link)
The link to the Community Support area is: https://www.experts-exchange.com/jsp/qList.jsp?ta=commspt
Please do not accept this comment as an answer!
Andriv
ASKER
No answer... Problem not solved
ASKER
No answer... Problem not solved
Are you still looking for an answer? If you are post your update query so I can take a look.
ASKER
No I have since moved jobs.
Sorry about that andriv the last thing (are you a moderator) the last thing I wanted to do was leave a question hanging about on a service that is so useful to me.
Thanx for the offer of help...
im makin a new php site at the moment no doubt I will need your help at some stage.
Apoligies and regards,
-Neil
Sorry about that andriv the last thing (are you a moderator) the last thing I wanted to do was leave a question hanging about on a service that is so useful to me.
Thanx for the offer of help...
im makin a new php site at the moment no doubt I will need your help at some stage.
Apoligies and regards,
-Neil
No problem neilhoman. In the future go to 'community support' when ever your question goes unsolved and request it to be deleted and it will be reviewed for deletion.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Maybe the permission of the database is READ only due to the user IUSR_.....
Check the permission and check the attribute of the file (maybe read only as well)