Phil said:
I am extremely new to VB so please excuse me in advance. I want to use VB
(within >Visual Studio.NET) to access a MS Access 2000 dbase. I want to be
able to manipulate the >Dbase inside VB. Would someone be willing to help
walk me through this process. Once I >am able to access just one of my
tables, I am confident I can take it from there, but I can't >even get to
that point. I know I have to create a OLE or ODBC connection, but I don't
have >any idea how to do that.
I am also a newbie to VB .NET, and I had a very similar problem to yours
recently. I think what you need to do is create an "OleDbDataAdapter." A
wizard should pop up and say, "Which data connection should the data adapter
use?" Click "New Connection." In the window that pops up, click on the
"Provider" tab and select "Microsoft Jet 4.0 OLE DB Provider."
After you click the "Next" button, select your database and check the box
for "blank password" (make sure there is no text in the "user name" text box
either). In the "Advanced" tab, select what kind of file access permission
you want. I usually don't even bother with the "All" tab. So push "OK" and
continue with the wizard. Click "Next" after you have selected "Use SQL
statements" (which is probably the only available option anyway). In the
next pane, you can use the query builder to access your database.
Once you've finished the wizard, you should have an "OleDbDataAdapter" and
an "OleDbConnection." Click on the "Data" menu and choose "Generate
Dataset..." Select what you want, and I am not so sure about what to do
after that. (I'm still figuring out how to manipulate the database that I'm
working with. :-D) Hope this works!
