Importing MS Access Databases to VB

[captainphoenix]

Windows XP Home Edition
VB 2005
MS Access 2003

I am having problems importing mdb information from access to visual basic. The first application worked fine, but the second one refuses to work, giving me a list of build errors pertaining to "[whatever] not defined..." see below

Error 1 Type 'AirlineReserva tionForm.Sennel lo_06DataSet' is not defined. C:\Documents and Settings\msenne l1\Desktop\hw6\ Airline Reservations\Ai rlineReservatio nForm\AirlineRe servationForm\A irlineReservati onForm.Designer .vb 28 37 AirlineReservat ions
Error 2 Type 'AirlineReserva tionForm.Sennel lo_06DataSetTab leAdapters.Flig htsTableAdapter ' is not defined. C:\Documents and Settings\msenne l1\Desktop\hw6\ Airline Reservations\Ai rlineReservatio nForm\AirlineRe servationForm\A irlineReservati onForm.Designer .vb 30 38 AirlineReservat ions
Error 3 Type 'AirlineReserva tionForm.Sennel lo_06DataSetTab leAdapters.Rese rvationsTableAd apter' is not defined. C:\Documents and Settings\msenne l1\Desktop\hw6\ Airline Reservations\Ai rlineReservatio nForm\AirlineRe servationForm\A irlineReservati onForm.Designer .vb 37 43 AirlineReservat ions
Error 4 Type 'AirlineReserva tionForm.Sennel lo_06DataSet' is not defined. C:\Documents and Settings\msenne l1\Desktop\hw6\ Airline Reservations\Ai rlineReservatio nForm\AirlineRe servationForm\A irlineReservati onForm.Designer .vb 195 45 AirlineReservat ions
Error 5 Type 'AirlineReserva tionForm.Sennel lo_06DataSetTab leAdapters.Flig htsTableAdapter ' is not defined. C:\Documents and Settings\msenne l1\Desktop\hw6\ Airline Reservations\Ai rlineReservatio nForm\AirlineRe servationForm\A irlineReservati onForm.Designer .vb 197 46 AirlineReservat ions
Error 6 Type 'AirlineReserva tionForm.Sennel lo_06DataSetTab leAdapters.Rese rvationsTableAd apter' is not defined. C:\Documents and Settings\msenne l1\Desktop\hw6\ Airline Reservations\Ai rlineReservatio nForm\AirlineRe servationForm\A irlineReservati onForm.Designer .vb 204 51 AirlineReservat ions


What I have in Access are two tables that link a list of passengers to a list of flights. The flight table has 4 fields: flight number (Key); departure city; arrival city; date. The passenger table has 2 fields: flight number; and name (key). They are linked via flight number. Queries were built to display the passenger list for each of the 5 destination cities: Boston, LA, Toronto, Dallas, and San Diego. The GUI contains (among other things not pertinent) a combobox, three textboxes, and a listbox. The combobox is supposed to display the flight number and allow the user to select from a dropdown list which flight number to display. The textboxes (located below the combobox) then display the rest of the flight information: Departure city, arrival city, and date. A listbox to the right of the textboxes is supposed to then display the related passenger list based on the flight number. However, I cannot get the import to work AT ALL. I am following the "Add Data Source" process to a 't' and when I debug (even with no values assigned to the controls) the above errors pop up. I know I need to give more information, but I figured this would at least be a start. Oh and the Access part is working fine in access.

In short, what am I doing wrong and how do I fix it?

ps how do I attach a screenshot to this post?

[debasisdas]

Question moved to .NET Forum.

[Shashi Sadasivan]

Hi,
Have you copied the dataset files from the previous project to the 2nd one?
If so refrence the namespaces accordingly...t hough that dosent seem to be the issue.

you can add a screen shot by editing the post !

[captainphoenix]

OK I think I've figured most of it out, but I've come to the query designer screen and it is not recognizing the SQL code I'm typing in. Specifically, in an attempt to return the name of each passenger in the listbox, the code I have input automatically converts to

WHERE (Name = '@name')

instead of

WHERE (Name = @name)

and I remember it had something to do with declaring the "@" symbol. Does anybody know where I'm going with this?

[captainphoenix]

bumpbumpbumpbum pbump