Re: Access 2000 with ADOTable error - Unspecified error


"Alan T" <alanNOSPAMpltse@xxxxxxxxxxxx> wrote in message news:478c158f@xxxxxxxxxxxxxxxxxxxxxxxxx
Sorry,

is the table name called 'session' a key word in Delphi?
Actually the table name is called 'session'.
Two things to try:
i) change your select query to: SELECT * FROM [TableName] <--i.e. put the tablename between square brackets
ii) Do a "Compact and Repair" of the database within Access in case any of the internal structures have become corrupt.

Good luck,
Andrew

.

Relevant Pages

  • Re: SQL Server Syntax error or access violation puzzle in VB
    ... I tried the square brackets idea - it didn't work. ... >> You need to use the syntax INSERT INTO tablename, ... >>> I've tried connecting with ODBC and ADODB connection strings. ...
    (microsoft.public.vb.database.ado)
  • Re: TADOConnection.GetFieldNames has bug
    ... MetaBase - ERWIN model in Delphi applications ... procedure TADOConnection.GetFieldNames(const TableName: WideString; ...
    (borland.public.delphi.database.ado)
  • Re: will Delphi 8 support Compact .Net FrameWork ?
    ... if the OS on the phone supports the .NET compact ... It may actually be possible to run an app created in Delphi ... > 8 on a phone that supports the compact framework now, ... Thank you Tim. ...
    (borland.public.delphi.non-technical)
  • Re: need help..(WHERE.....OR (Right(original_missing.field2,6) = R
    ... Try surrounding the tablename with square brackets. ... helpmeplease wrote: ... > it's saying that i have a syntax error when i go to save either of those ...
    (microsoft.public.access.queries)
  • Re: Compact vs. Regular .NET
    ... > such basic functionality as Object methods out of the compact ... certainly managed to live without it in Delphi for a number of years. ... InterBase PLANalyzer 1.1 -- Free InterBase query optimization ...
    (borland.public.delphi.non-technical)