Run Time Error 3131

Tippy

unread,

Feb 2, 2000, 3:00:00 AM2/2/00

to

Hi there,

A friend of mine is the membership secretary for a local charity and
is suddenly getting errors in a data base that's been running fine for
years on Access 97.

There has been no recent changes to anything on the PC as far as I
know, even the backup copies are giving the same error and never did
before. Even the original database with no entries in gives the error.

The error is 3131 Syntax Error in FROM Clause.

Does anyone know what could have caused this and possibly how to solve
it. Office has OSR1 and OSR2 installed.

Any help would be greatly appreciated.

Rgds
Darren.
--
Darren Tipton.
Remove the obvious to reply via email.

Roger Eng Kiat Stout

unread,

Feb 4, 2000, 3:00:00 AM2/4/00

to

Tippy wrote:

The error relates to an invalid SQL string (a query) which is being
executed from code.

Specifically, this can occur when the SQL string is incomplete e.g.
"SELECT * FROM;" as opposed to "SELECT * FROM tblExample;"

Personally I would consider it unlikely that this is an error with
Access. If you are sure nothing has changed as well then possible
database file corruption has occurred.

I could not say more without knowing the exact circumstances of the error
and looking at the code which produces it.

Regards,

--
Roger E K Stout
Programmer
Integration & Support
EASAMS Ltd
Tel 01785 782339
Fax 01785 244397

Tippy

unread,

Feb 4, 2000, 3:00:00 AM2/4/00

to

Hello Roger,

Thanks for your post, I can send you a copy of the database file if
you like to take a look at. It would be greatly appreciated :-)

Rgds

Logicus

unread,

Feb 8, 2000, 3:00:00 AM2/8/00

to

On Wed, 02 Feb 2000 18:11:58 GMT, "Tippy" <ne...@removethistippy.co.uk>
wrote:

>Hi there,
>
>A friend of mine is the membership secretary for a local charity and
>is suddenly getting errors in a data base that's been running fine for
>years on Access 97.
>
>There has been no recent changes to anything on the PC as far as I
>know, even the backup copies are giving the same error and never did
>before. Even the original database with no entries in gives the error.
>
>The error is 3131 Syntax Error in FROM Clause.
>
>Does anyone know what could have caused this and possibly how to solve
>it. Office has OSR1 and OSR2 installed.
>
>Any help would be greatly appreciated.
>
>Rgds
>Darren.

Somewhere in an SQL code there is an error. You should check your
Queries. It could however also be an embedded SQL in one of the
reports or forms or even the embedded Visual Basic code. Sorry that's
about all the help I can give you from here.

Regards,

Bob

David Robinson

unread,

Feb 12, 2000, 3:00:00 AM2/12/00

to

If database corruption has occured then you could try repairing the
database. Have you tried installed access again ? There is a post Y2K patch
that you can apply that may help. Has this suddenly started happening after
the dreaded 2000 has ticked over ?

Have you tried the database on another machine ?
Roger Eng Kiat Stout <roger...@gecm.com> wrote in message
news:389AA16A...@gecm.com...

> Tippy wrote:
>
> > Hi there,
> >
> > A friend of mine is the membership secretary for a local charity and
> > is suddenly getting errors in a data base that's been running fine for
> > years on Access 97.
> >
> > There has been no recent changes to anything on the PC as far as I
> > know, even the backup copies are giving the same error and never did
> > before. Even the original database with no entries in gives the error.
> >
> > The error is 3131 Syntax Error in FROM Clause.
> >
> > Does anyone know what could have caused this and possibly how to solve
> > it. Office has OSR1 and OSR2 installed.
> >
> > Any help would be greatly appreciated.
> >
> > Rgds
> > Darren.

> > --
> > Darren Tipton.
> > Remove the obvious to reply via email.
>