Re: Using Access 2000 db with VB 6

Check out the SQL statement you are using..

Post the SQL statement and maybe we can see something wrong with it...

--
Chris Hanscom - Microsoft MVP (VB)
Veign's Resource Center
http://www.veign.com/vrc_main.asp
--
Read. Decide. Sign the petition to Microsoft.
http://classicvb.org/petition/


"surcharge" <surcharge.1ozn7h@xxxxxxxxxxxxxxxxxxxxx> wrote in message
news:surcharge.1ozn7h@xxxxxxxxxxxxxxxxxxxxxxxx
>
> I get this error message when I try to get data from an Access 2000
> database: Syntax error in From clause.
>
> This is the provider I'm using:
> Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and
> Settings\ceriksen\My Documents\FL SIRePository\FL SIRePository
> V1.0\SIRpository.mdb;Persist Security Info=False
>
> This works with an Access 97 version of the database but not the 2000
> version.
>
> How do I view the From clause to fix it?
>
>
>
> --
> surcharge
> ------------------------------------------------------------------------
> Posted via http://www.codecomments.com
> ------------------------------------------------------------------------
>


.

Relevant Pages

  • Re: Application Speed Dilemma
    ... If yes, then it will work faster, because database is ... >> SELECT SQL statement with WHERE clause then check if you have indexes ... >> in a database for the fields involved into this WHERE clause. ... >> have indexes, then it could be very slow process, since it would require ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)
  • Re: Application Speed Dilemma
    ... If yes, then it will work faster, because database is ... >> SELECT SQL statement with WHERE clause then check if you have indexes ... >> in a database for the fields involved into this WHERE clause. ... >> have indexes, then it could be very slow process, since it would require ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: SELECT TOP Flaking Out...
    ... As for the WHERE clause, it returns what I thought it should. ... Both use SELECT TOP n in the SQL statement to get ... You should use the Query Builder to create and debug ... > version of database you are using ...
    (microsoft.public.inetserver.asp.db)
  • Re: SQL Help
    ... "Jon Spivey" wrote in message ... > Microsoft MVP - FP ... >> same sql statement? ... >>>>I want a count of each month entered into my database ...
    (microsoft.public.frontpage.client)
  • Re: Application Speed Dilemma
    ... > Hi John, ... If yes, then it will work faster, because database is local ... > SELECT SQL statement with WHERE clause then check if you have indexes ... > in a database for the fields involved into this WHERE clause. ...
    (microsoft.public.dotnet.framework.windowsforms.databinding)