Syntax Error in From Clause - Nothing Changed...?

[sandog]

When I make any changes to the database I get an error - "Run-time
error '3131': Syntax error in From clause.

I'm using access 2000
I get this when I try to make a new form. Nothing changed in the
database.
I get the error even when starting from a blank database.
I tried reinstalling access but that didnt help.

I found a post w/ someone who had the same problem, but no one had a
resolution.
http://groups.google.com/group/micr...+syntax+error+in+from+clause#599cc27c0f3e8573

 

[Stefan Hoffmann]

hi,

When I make any changes to the database I get an error - "Run-time
error '3131': Syntax error in From clause.
I'm using access 2000
I get this when I try to make a new form. Nothing changed in the
database.

Did you assign the SELECT manually? Check if the table name is enclosed
into square brackets []. Maybe you are using a reseverd word.

I get the error even when starting from a blank database.
I tried reinstalling access but that didnt help.

What OS do you use? Have reinstalled MDAC/JET 2.8 also?


mfG
--> stefan <--

 

[sandog]

hi,

When I make any changes to the database I get an error - "Run-time
error '3131': Syntax error in From clause.
I'm using access 2000
I get this when I try to make a new form. Nothing changed in the
database.

Did you assign the SELECT manually? Check if the table name is enclosed
into square brackets []. Maybe you are using a reseverd word.

I get the error even when starting from a blank database.
I tried reinstalling access but that didnt help.

What OS do you use? Have reinstalled MDAC/JET 2.8 also?

mfG
--> stefan <--

I'm running XP. I reinstalled the MDAC and JET but it didn't help.
I'm thinking maybe a recent update blew it out.
By the way, I checked other computers, and there having the same
effect...