Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Jet OLEDB:Database Password=MyDbPassword;
I am new to VB.NET and the above code I can't seem to get it to connect to my database. I am rusty on all my coding abilities and wish to start this project from scratch. Am not looking for anyone to do my homework. Visual Studio 2008 underlines post of the connection string so I know it will error before trying to run the app. I might as well be a beginner when it comes to databases. I know I should be using Dim keywords but not sure what? This is my first attempt with VB.Net and am trying to learn enough to complete a Cook Book database. I will have many more questions later on in this post I'm sure. All I have to go on for an access database is a connection string that alone will not connect. I do not wan't anyone to give me sample code, I can find plenty of sample code for databases on the net. What I wan't is to learn database programming step by step, one line at a time. It is easy to copy and paste code, but I wan't to learn .net coding hands on. My goal is to be able to write any kind of database app from scratch on my own. If you decide to help me with this project please explain your given code where I can understand it.
I am here to learn and am glad to find a site willing to help. In the past I got by, by copying and pasteing code. I am a amature programmer dabbling in different coding languages. I am disabled and I have got to the point that I want to learn from scratch instead of using a template. Here in this forum post I want to learn from scratch how to program a simple database program. There are sample code all over the net for databases, but I came here hoping to learn one code at a time. The code or connection string I posted above I understand most of it, but not ACE.OLEBD.12.0 Please help me to understand what I am writting and help me with what is missing and hopefully explain the code in some detail. If you help me I will help someone else.
In the past I learned what I knew from other peoples sample code. Copying and pasteing was a way of life. Until now there was no one to ask how to do something and what the code means. If you have an itch to teach, then I am here to learn Help me write a cook book database and help me know what every line of code means. Once again I don't want anyone doing my homework, so give me homework to do and I will do what you advise.
I don't see a spell check button here so hope I spelled ok?