Database Syntax Error


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 7 of 7

Thread: Database Syntax Error

  1. #1
    Join Date
    Dec 2005
    Posts
    13

    Database Syntax Error

    Ok I am using the ADODC and DataGrid on my form. I am connecting to a database on my local drive which was tested last week. Now when I come back to do the same thing, once I establish the datasource on the datagrid to adodc1, a little message box pops up and says "Syntax Error in From clause"

    What in the heck is this saying and how to fix it? I am not using code anywhere and I'm a little confused at where to begin.

  2. #2
    Join Date
    Jan 2006
    Location
    Saudi Arabia
    Posts
    8
    Syntax Error in From[B] clause
    I Think There Is a Problem In The Table Which You Are Reading From
    Check It's Name And Structure
    I Hope You Will Find The Bug.

  3. #3
    Join Date
    Dec 2005
    Posts
    13
    Yeah I am thinking thats where the problem lies at. Not sure where to begin at the table level.

    I also get unrecognized database format some times. Seem as though Access 97 files work fine but Access 2000 doesn't work. Any ideas here?

  4. #4
    Join Date
    Dec 2003
    Posts
    2,750
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  5. #5
    Join Date
    Dec 2005
    Posts
    13
    I believe the recordsource was one of tables within the mdb.

  6. #6
    Join Date
    Dec 2003
    Posts
    2,750
    Can you identify the name of the table? The only thing I can think of is that the name of the table or name of a column is a reserved word.
    Paul
    ~~~~
    Microsoft MVP (Visual Basic)

  7. #7
    Join Date
    Dec 2005
    Posts
    13
    I dont have access to the program right now. I'll take a look and double check it tonight......

Similar Threads

  1. Returning errors from SQL Server Stored Procs
    By Khalizan in forum VB Classic
    Replies: 1
    Last Post: 11-28-2001, 02:32 AM
  2. MS-Access Error - Obsolet Database Format !
    By Makl. Lemmertz in forum VB Classic
    Replies: 2
    Last Post: 10-29-2001, 12:12 PM
  3. Still SQL Syntax Error
    By Lola in forum VB Classic
    Replies: 4
    Last Post: 06-15-2001, 10:24 AM
  4. Replies: 0
    Last Post: 08-13-2000, 10:46 PM
  5. ADO error -2147217900 INSERT INTO Syntax error
    By Ray Parrish in forum VB Classic
    Replies: 0
    Last Post: 03-24-2000, 01:23 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center