Need VB.NET code to validate data entered and saved in Access 2003 Database.

Question

0.00/5 (No votes)

See more:

Need Help.

I have created a Windows application in VB.NET which collects user inputs and stores them in MS Access 2003 database.

However I have been searching for VB.NET code that I can use to validate information entered through the VB.NET interface, most importantly I want code that would validate data entered from being duplicated in the database.

Specifically, I want code that would validate the primary key from being entered which would produce a duplicated record.

Thanks.

Posted 17-Nov-10 14:33pm

Samantha Sam

Updated 23-Nov-10 23:49pm

Slacker007

v2

Add a Solution

Comments

Maciej Los 23-Nov-10 16:29pm

So, you should ask your database...
Need more information about your database, a specialy about primary key, relations...

2 solutions

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)

Slacker007 · Answer 1 · 2010-11-23T23:47:00

In MS Access if you set your key to be Primary and it is unique then it would be impossible for you to enter a duplicate value. The database won't let you perform a duplicate action on a key that already exists.

If you are doing this through code then you would want to perform a SQL statement against the database looking up the key value. If no records are returned then you know that your key value is unique.

Please note, that if you are going up against a large table in your database, and since it is Access, you are going to most likely have problems with performance.

I would recommend that you use SQL Server Express 2005/2008, it is lightweight and powerful and is better in performance than MS Access. It will also allow you to use Stored Procedures and Triggers among other things as well. Good luck!

HTH

Simon_Whale · Answer 2 · 2010-11-24T00:39:00

Solution 2

Further to Slacker007's answer

If you enter duplicate values in a Primary Key column it will through an error in your code.

But if I remember rightly in Access you can use a autonumber column.

Posted 24-Nov-10 0:39am

Simon_Whale

Comments

Slacker007 24-Nov-10 10:11am

That is correct Simon. There is a Autonumber property for the column if it is going to be used as a primary key.