Re: Query with left outer join all of a sudden won't work?
- From: "Michel Walsh" <vanderghast@VirusAreFunnierThanSpam>
- Date: Wed, 4 Jun 2008 09:18:44 -0400
Just in case, can you check if the log file has enough room to accommodate
the outer join? Someone mentioned me there could be similar problem with
older MS SQL Server ( I was on the impression you were using MS SQL Server
6) if the log file was full.
Vanderghast, Access MVP
"JenniferW" <JenniferW@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D15940A7-DF48-4115-A0EC-38D916CEB5D3@xxxxxxxxxxxxxxxx
I have a database with an Access frontend and a SQL 2000 backend. I moved
the data in the database from Access to SQL 6 months ago and it has worked
fine. Then someone went to run a query this week that has a left outer
join
and all of a sudden it won't work. It gives an error of "ODBC call
failed".
I at first thought maybe there was some bad data but I have a copy of this
database from March in our SQL 2005 server and it also doesn't work. So,
it
doesn't seem like it could be a data problem when this query worked fine
last
month with our current data but now won't work with current data or data
that
hasn't been updated since March. So, this makes me think there has been
some
Microsoft update that has happened in the last month and now is causing
problems. Has anyone else had a problem with left outer joins all of a
sudden not working?
Thanks for any help you can give.
.
- Prev by Date: RE: working with time date in a query
- Next by Date: Limit Records
- Previous by thread: Re: Query with left outer join all of a sudden won't work?
- Next by thread: Re: Query with left outer join all of a sudden won't work?
- Index(es):
Relevant Pages
|
