"The Microsoft Access database engine cannot find the input table or query 'Huollot'.

[IsInTrouble]

My program is working fine (windows forms and access database) and tables that I have done in beginning of the project are also being read and updated.

Now I needed to add a new element to a program which needed another table, which I added to access database. Information of the table is used in datagridwiev which I added to a form. After choosing the table as a datasource the program add following code, which then does not work.

private void Huollot_Load(object sender, EventArgs e)
 {
 // TODO: This line of code loads data into the 'harjoitustyoDatabaseDataSet.Huollot' table. You can move, or remove it, as needed.
            this.huollotTableAdapter.Fill(this.harjoitustyoDatabaseDataSet.Huollot);
}

the error code again "The Microsoft Access database engine cannot find the input table or query 'Huollot'. Make sure it exists and that its name is spelled correctly."

I would be so gratefull of any help whith this topic.

[zmbd]

IsInTrouble:
The error is fairly straight forward, you either have a typo in the table name in the code, or the connection you have made to the database does not include the table.

1) You need to make sure that the names match between the code and the database.

2) You need to check to make sure that you are connecting to the correct database file.

[IsInTrouble]

Right you are. Checked files once again and found two databases. Deleted other one, refreshed connections and now it's working just fine. Thanks for your help!

[zmbd]

I always like the simple fixes... they're the best (^_^)
Glad I could help!
BOL w/remainder of the project!