View Single Post
  #1 (permalink)  
Old July 7th, 2005, 11:27 AM
braheem braheem is offline
Registered User
 
Join Date: Jun 2005
Location: , , .
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to braheem Send a message via Yahoo to braheem
Default Diplay records from database

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 hsimpson@snp.com
2 Carl Carlson 212K352981 ccarlson@snp.com
3 Lenny Leonard 212K363284 lleonard@snp.com


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

Reply With Quote