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
neilhomanAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

us111Commented:
is your databse in your web root (bad for security) ??
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)

0
neilhomanAuthor Commented:
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
0
neilhomanAuthor Commented:
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.
0
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

MoondancerCommented:
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:  http://www.experts-exchange.com/jsp/cmtyHelpDesk.jsp  
0
andrivCommented:
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: http://www.experts-exchange.com/jsp/qList.jsp?ta=commspt

Please do not accept this comment as an answer!

Andriv
0
neilhomanAuthor Commented:
No answer... Problem not solved
0
neilhomanAuthor Commented:
No answer... Problem not solved
0
andrivCommented:
Are you still looking for an answer? If you are post your update query so I can take a look.
0
neilhomanAuthor Commented:
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
0
andrivCommented:
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.
0
MoondancerCommented:
Thanks to you both.

I have refunded your points to you, Neil, for this question and moved it to the PAQ at zero points to close it.  This way, when you wish to pursue further, you can post a new question and point to this link as reference to minimize additional back-tracking and work in the new effort.

Moondancer - EE Moderator
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.