Updating MS Access from Application?

Question

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.!!

Posted 12-Sep-12 23:15pm

Dale 2012

Updated 12-Sep-12 23:16pm

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

**AmitGajjar** · Accepted Answer · 2012-09-12T23:53:00

Solution 1

Hi,

Check Insert, Update, Delete & Search Values in MS Access 2003 with VB.NET 2005[^] Article.

Posted 12-Sep-12 23:53pm

AmitGajjar

Comments

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.

Dale 2012 14-Sep-12 6:17am

ok perfect how might i go about autogenerating the id?

Dale 2012 14-Sep-12 6:17am

I will mark as answered once you reply

thank you once again

AmitGajjar 14-Sep-12 6:22am

check http://blogs.office.com/b/microsoft-access/archive/2010/04/02/power-tip-create-an-autonumber-field-that-starts-with-a-number-greater-than-1.aspx

AmitGajjar 14-Sep-12 7:24am

got any success ?

Dale 2012 14-Sep-12 7:30am

This link is a bit vauge to my problem.....

All i wish to do is have some way were I do not need to add the primary key myself but have my program do it for me. I need the primary key field to be updated without the need to specify the field number in the vb.net program

any idea how to auto generate the primary key?

AmitGajjar 14-Sep-12 7:34am

what about http://office.microsoft.com/en-us/access-help/create-or-remove-a-primary-key-HA010014099.aspx

if you search in msdn you can find lot of material.

Dale 2012 14-Sep-12 22:24pm

sorry i think you miss understand my problem.. I need to do what you have shown me by code only.... I need a way to update the AU_ID with code.

my question is how might i determine the value of the last inserted value in AU_ID so that I can add one to that so it does not coflict with the database.

I think that would be the easiest way.

thank you in advance

AmitGajjar 14-Sep-12 23:15pm

Ok, With the MSACcess it would be very difficult. At first look it is very easy but it may cause some other consistancy problems. But you need to find max value from the ID column from the Code and then you can increment it, But don't forgot to lock the function when executing. hope you have idea to create such function in vb.net

Dale 2012 15-Sep-12 3:58am

thank you I have completed my objective and have the correct integer values I need to work with the database

thank you once again for all your help the question is now closed

thanks again friend!!

AmitGajjar 15-Sep-12 3:59am

Your welcome friend.