Error 2147217900

Hi,
it sounds like quotes weren't added for some key field values. I would recommend to use a single field as a key.
Could you also zip and send me your database. Send it to support AT xlinesoft.com.
Best regards,

Sergey Kornilov

Hi,
I would recommend to use ID as a key column. This should solve this problem.
Best regards,

Sergey Kornilov

OK,
I see you have given instruction to "No no" on an Error "-2147217900". I have found the same when attempting to carry out an edit function - and your solution doesn't work! re: "[Microsoft][ODBC Microsoft Access Driver] Syntax error in UPDATE statement."
The database has only 43 fields including ID. I would prefer to have the option of other Key fields as this makes the product ASPRunner quite attractive! (Was quite attractive)
I have reduced the number of "Keys" to one - and to the ID only.
I haven't altered any field position. I have opted for all fields to be searchable in both capabilities Search and Advanced.
I have carried out a repeat test on the various options available and still the same error repeats. I'm curious to know what the solution is...? A scripting error?
I have been able to edit the database with another product but I thought I'd check this one out.....
How fast do you answer your enquiries? Hope it is speedily. thank you.
Talker

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=768&image=1&table=forumreplies' class='bbc_emoticon' alt=':angry:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=768&image=2&table=forumreplies' class='bbc_emoticon' alt=':(' />

Talker,
please zip and send me all files from ASPRunner's output folder (ASP files, include files and some portion of your database).
Just send it to support AT xlinesoft.com. I will find what's wrong and be back to you.
Best regards,

Sergey Kornilov

OK,
Give me a few minutes
Talker

Zip sent. Have you received it? Link playing up.......

Hi,
haven't received it yet.
Best regards,

Sergey Kornilov

Re-sent
Could be you receive two.....
;-)
Talker

Talker,
still don't have it. Make sure email address is spelled correctly.
Best regards,

Sergey Kornilov

Hi Sergey,
I have had one email bounce on the address I obtained from above - I replaced the AT with the "@" ....
I have "winged" a third attachment to you...... this morning...
I have also sent you a further email without an attachment as a check.
Talker
:-)

For Sergey,
Thank you for responding so promptly to this posting and to the emails I have sent to you.
Your effort to correct this problem has been faultless - in fact I'd say superb, thank you.
For everyone:

The problem itself wasn't with ASPRunner but with the use of "text" and "percent" in the database fields. Ones these names had been changed to the Edit function worked a treat.
Sergey wrote: "I found what the problem is: you have fields named "percent" and

"text" that are MS Access reserved keywords. This breakes SQL query

when you trying to update database. Changing field names will fix the

problem."
Sergey also provided a replacement file as a workaround should I not have been able to alter the database field names... Although not used...thank you.
ASPRunner is a super product.... well worth trying out....
Talker

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=776&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=776&image=2&table=forumreplies' class='bbc_emoticon' alt='B)' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=776&image=3&table=forumreplies' class='bbc_emoticon' alt=':D' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=776&image=4&table=forumreplies' class='bbc_emoticon' alt=':lol:' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=776&image=5&table=forumreplies' class='bbcemoticon' alt='<<' /> <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=776&image=6&table=forumreplies' class='bbc_emoticon' alt=':rolleyes:' />

Thought this link might be appreciated and could be useful!
Reserved Access, ODBC and T-SQL keywords..

Hi Talker,
I can't express how much the link above will help me - both with code Runner generates and my own. I've run into several problems where I've used some of these reserved words as field names and it causes all sorts of wonderful errors to play with. :-D
Thanks again, that will come in extremely handy.
Becca