Error populating datatables with data from Access file
I've just switched from VB 6.0 to VB 2005 Express, and I'm finding it extremely difficult to do anything that could be easily accomplished in VB 6. I'm trying to develop a *very* simple application (to learn the IDE, mainly) to convert one unit to another (i.e., a single computational step). Conversion factors are contained in five separate, but unrelated, tables in an MS Access file. When I connect to the Access file, the 'test connection' is successful. Following the "New Data Source" wizard, I can successfully copy the Access file to the local VB project, and then save the connection string. After I select my tables from the Access file, and click the "Finish" button on the wizard, I get the following error:
"An error occurred while creating the new data source: Could not get type information for 'AccessFileName_TablesDataSet'.
This then generates 102 error messages in the Error List window (all the same), saying "Reference to a non-shared member requires an object reference." (The help facility did nothing to aid my understanding of the error.)
Upon double-clicking an error message, I'm taken to the AccessFileName_TableDataSet.Designer.vb page, where there's a lot of IDE generated code. Each error (denoted by a blue line under the offending stmt) occurs under the word "System" on a line that looks like this:
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Property somevar As Double
I've tried importing tables individually by first adding a DataSet to the project, then generating tables with tableadapters that point to individual tables in the database file. That at least gets the data into the project, but eventually leads to the generation of the same 102 error messages. Consequently, I can't use the data for anything.
I've also tried pointing to other Access files having a much more sophisticated schema (i.e., more tables, complex relational structure), and don't seem to have any problems getting data into the VBE project. It's the simple connection that doesn't seem to work.
I have absolutely no idea as to what's going on here--so any help would be most appeciated.
Thanks,
Greg.
