MS Access Problem

Star09

OleDbConnection clsConnection;
clsConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\\.one.mdb;");
clsConnection.Open();
//first table
WTest1.oneDataSet f_table = new WTest1.oneDataSet();
OleDbDataAdapter dAdapter = new OleDbDataAdapter("select * from first", clsConnection);
dAdapter.Fill(f_table, "first"); // runtime error incorrect FROM syntax
clsConnection.Close();

I've used this code in a previous application and it worked fine, however in this application, it's giving me this error about FROM syntax. Can someone please tell me what's wrong??:confused: Star

musefan

are you sure there is table called 'first' and also do you have 2 spaces between 'from' and 'first'. Im sure queries don't like double spaces

Life goes very fast. Tomorrow, today is already yesterday.

Luc Pattyn

Star09 wrote:

Data Source=C:\\.one.mdb

do you need the first period? :)

Luc Pattyn [Forum Guidelines] [My Articles]

Avoiding unwanted divs (as in "articles needing approval") with the help of this FireFox add-in

Star09

I have removed the path because it was so long, but I do have it in my application, lol. As for the double spaces, didn't notice them, thanks, but still even though I removed the double spaces, still same runtime error

musefan

Star09 wrote:

As for the double spaces, didn't notice them, thanks, but still even though I removed the double spaces, still same runtime error

you should reply that message to me.... What is the error message you are getting?

Life goes very fast. Tomorrow, today is already yesterday.

Star09

the message doesn't make sense, Syntax error in FROM clause.

Star09

Okay when I commented my other connections, it worked.