Click here to Skip to main content
15,849,594 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I have tried many examples now to write or update ms access database with entries from my program. My problem exists with not being able to mix numeric with alphanumeric values with the program crashing.

It might sound like a novice question and if it is I appologize but how can I add any value I want to any area of my database?

lets say for example I wish to add 6SW2CV87-321 to my table under the first field is that possible to also add that exact same string to all?

thank you in advance Im pulling my hair out over this for probably no reason.!!
Updated 13-Sep-12 0:16am

1 solution

Share this answer
Dale 2012 13-Sep-12 20:20pm    
thank you for this example but I am worried to try this.... in the ID section will i be able to add my string 445323BFGF or anything i wish to add or will it need to be only numbers?..... and in the second field where author does the incerted text only can contain text or can i insert text and numbers?.... that is the origin of my question

thank you in advance
AmitGajjar 13-Sep-12 22:56pm    
As far as your ID is identity value you can use it for update. if you are not sure then you can add one select query before update and you can check if single value exist for that particular Id.
Dale 2012 13-Sep-12 23:58pm    
thank you i have the program now but would like to know if the Author Id can be excluded so that i can add anything to the rows after it....
AmitGajjar 14-Sep-12 0:55am    
if your AuthorId is autogenerated then you can add in row without authorid.
AmitGajjar 14-Sep-12 1:13am    
if you feel i answered your query, don't forgot to mark solution as answered. that may help other to identify.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900