How do i...save records in an empty access database file without any error message via VB.NET

Question

1.00/5 (2 votes)

See more:

Hello Everybody,
I'm using vb.net VS 2015 with MS Access 2013 as a database, My problem is occurring when i get my access database file with no data(i.e remove all the data from the fields in the database tables to start the application with no data).The error message appears (on click my save button) when i try to save my first record in the database and when i click my empty data grid view the same error also occur...
The error message says "object reference not set to an instance of an object".

What I have tried:

But when i return my old database file(filled with an old data)my application work in normal way without any error messages.............
Any suggestions would be appreciated
Thanks in advance

Posted 10-Aug-17 10:48am

amr aly

Updated 11-Aug-17 0:51am

Add a Solution

Comments

Patrice T 10-Aug-17 19:13pm

And you have some code with that error message ?
The error message should have come with the position of error.

amr aly 11-Aug-17 3:52am

Thank you sir for your fast response.You solved my problem by saying"The error message should have come with the position of error." my problem solved because i remove try and catch code then the error become clear and when i changed my code my app work normally and i knew where the position of the error code.Many thanks sir

amr aly 11-Aug-17 4:25am

But when i changed my code another problem appear but with no error. The code that i removed it i want using it in my app, i will try to solve this issue if i can't i'll return here to explain my new problem.The question is "Can i explain my new problem here or write another post?" thank you for all team in Code Project

Patrice T 11-Aug-17 6:41am

Use Improve question to update your question.
So that everyone can pay attention to this information.

try to show code too.

amr aly 11-Aug-17 7:11am

Thank you sir, I'll do so

Graeme_Grant 10-Aug-17 20:14pm

There are many different ways to bind the view to the data and then update the database however the SQL commands are very specific. Without knowing if your app is WinForm, Wpf, Xamarin, Asp.Net WebForms, or MVC, and seeing any code, it is hard to give you any meaningful response.

Please update your question by clicking on the "Improve question" widget. If you are uncertain how to do this, please read the following: How to improve your question information - Code Project Quick Answers FAQ[^]

amr aly 11-Aug-17 3:59am

Thank you sir, The article so helpful

Graeme_Grant 11-Aug-17 7:09am

I am not sure how it was helpful as I still can't see any code or what type of project you are doing... Understand, we can't see your screen where the code with the problem is, nor any error messages, so we can't help you.

amr aly 11-Aug-17 7:32am

Mr ppolymorphe Says"And you have some code with that error message ?
The error message should have come with the position of error.",These words gave me attention about that my code include (try and catch Exception) when i removed try catch Exception the error become clear to me and easy to deal with(Changed some piece of code and my app work normally),But when i changed my code another problem appears but with no error.I will try to solve this issue if i can't i'll return here to explain my new problem.Many thanks sir for paying attention about my problem

amr aly 11-Aug-17 7:36am

By the way my project is WinForm app.
Called (KMA Clinic)

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)

Patrice T · Accepted Answer · 2017-08-11T00:51:00

Quote:
How do i...save records in an empty access database file without any error message via VB.NET

This comment
'And you have some code with that error message ?
The error message should have come with the position of error.'
solved the question because it gave idea to remove the try/catch, letting VB spit a nice error message.