docmd.runSQL fails on Windows 2000
Hmm, do your SQL based on queries? then probably some query get corrupted.
the try to recreate it
--
Alex Dybenko
http://Alex.Dybenko.com
Quote:
> Actually, Access generates some error log and quits. I have yet to see
this
> error log (two users are having the problem, and I haven't had a chance to
> do very much testing on it myself.)
> Thanks.
> Dylan.
> > Hmm, what error you get with .RunSQL?
> > > I am having a problem where a program that I wrote that uses a lot (a
> > whole
> > > lot...) od DoCmd.RunSQL statements keeps failing on computers using
> > Windows
> > > 2000 Professional. If you take the same SQL and define a QueryDef
there
> > are
> > > no problems (except for the hours of rewriting for me..) I was
> wondering
> > if
> > > anyone else had encountered this problem, and had possibly found a way
> > > around it. (Access 97 on Windows 2000) As far as I can figure, it is
a
> > > problem with permissions, because their are no permissions assigned to
a
> > > simple SQL statement, but there are to a QueryDef object. Any thoughts
> > would
> > > be greatly appreciated.
