Solve This One...

[Guest]

I have an invoice database in Access 97. We are rebuilding it in Access XP.
One query works fine in 97. You can open it, edit it, save it, whatever.
But after I have rebuilt it in XP, even when rebuilding it using all the
tools to build queries in XP, and I go to save it ,Access just quits and
nothing gets saved. It doesn't give me an error, nothing. I just get flat
kicked out of Access. Any ideas?

 

[Wayne Morgan]

I've seen this with some versions of Jet 4. Verify that you have the latest
service packs installed for Office XP, Jet, and MDAC. As a work around, I've
sometimes seen that removing unneeded brackets and parentheses from the SQL
of the query will help. By unneeded, any name that doesn't have a space in
it shouldn't need brackets and frequently Access will bury WHERE clauses 3
or 4 levels deep in parentheses when none are needed.

Another possibility is that there is something corrupted in the file. For
information on this, see this link.

http://members.iinet.net.au/~allenbrowne/ser-47.html

 

[Ken Snell [MVP]]

Also, turn off Name AutoCorrect feature (Tools | Options | General tab). It
causes this type of behavior as well.