Hi I am trying to display a few records from MS Access but I keep getting an error stating:
System.Data.OleDb.OleDbException: The Microsoft Jet database engine cannot find the input table or query 'MailingList'. Make sure it exists and that its name is spelled correctly.

I have a database called test.mdb with a table called MailingList, which contains the following data:

MailinList

MailingListID FirstName LastName WorkPhone EmailAddress
1 Homer Simpson 212K345835 [email protected]
2 Carl Carlson 212K352981 [email protected]
3 Lenny Leonard 212K363284 [email protected]


What I want my query to do is display the first name and last name in the MailingList table. The query I am using is:

string strSQL = "SELECT MailingList.FirstName, MailingList.LastName FROM MailingList";

Which should display the first and last names, when I do that it generates the error I mentioned above. Any idea whats wrong with it I have been working on this for two days and just need some fresh eyes to take a look at it. Any help is greatly appreciated.

Thanks,
braheem

If you don't mind, could you just post your complete code for the page?

Hi braheem,

As you say in your post, the table name seems to be MailinList(g missing). Check if the table name is the same in the mdb file, as what you use in the SELECT query.

_________________________
- Vijay G
Strive for Perfection

Please ensure the name of table you used inside SQL statement is correct. You may provide the full code.