whats going on?

[Steven Burn]

I'm getting the following error when trying to access any of the tables in
one of my databases. I've tried Compact and repair but that hasn't fixed it.
Any ideas?.

Error message: Syntax error in query expression 'szObject = wszTableName or
szReferencedObject = wszTableName'

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk

 

[Ken Snell]

Offhand, it appears to be a syntax error..... <grinning & ducking!>

Seriously, can you provide more info that will help us see what you're
doing? Can you post the SQL statement of the query that is creating this
error? Why do you think you need to compact/repair to fix this -- was it
working before and now has stopped working? If yes, have you tried importing
all objects into a new database to see if that fixes the problem?

 

[Steven Burn]

Ken, I can't actually provide any more info as it won't allow me access to
the database at all.

It just gives that error when trying to access any part of it. It used to
work fine until I converted it from Access 97 to Access 2000 format.

The reason I tried compact/repair is basically because, everyone seems to
reccomend it whenever there is an issue with a DB.

The DB itself works fine online (where it is meant to work), it only seems
to be a problem when trying to open/view/edit it in Access itself.

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk

 

[Ken Snell]

I'm sorry, but I have nothing that I can suggest. The error that you're
seeing suggests that a query is trying to run when you open the database,
and that query doesn't like that statement that it's showing you. Without
knowing what the query is doing, what the SQL statement of the query is, and
what the meaning of the "variables" that are in the query expression, I
wouldn't know where to start.

 

[Steven Burn]

Ken, frankly, it's got me stumped too. Especially as I don't have anything
in it that would try and load/run when the database is run offline, let
alone when it is opened offline.

--
Regards

Steven Burn
Ur I.T. Mate Group CEO
www.it-mate.co.uk

 

[Ken Snell]

Only thought (and I have no experience with web databases) is that there is
something that the database runs in the web environment that does not
properly run in a non-web environment. Just a wild guess.