ODBC--call failed

Oldman · External Since: Sep 23, 2009 Posts: 1

Using Access 2007 linking to a new SQL 2005 database. We can get to most all
of the tables within a database without any problems but there are a few that
we get ODBC--call failed. This is not happening on all of our workstation
and on one it worked the first time but when I went back to do it again it
failed.

I am guessing a possible timeout issue/settting but not for sure.

--
Thanks

Bob Larson · External Since: Jan 19, 2009 Posts: 6

Make sure you are using the correct ODBC Driver (SQL Native Client, if on
WinXP and SQL Server if on Vista or 7)

--

Bob Larson
Access MVP

"Oldman" <Oldman.DeleteThis@discussions.microsoft.com> wrote in message
news:3E1EA8F0-1043-4A17-B12E-95B793454151@microsoft.com...
> Using Access 2007 linking to a new SQL 2005 database. We can get to most
> all
> of the tables within a database without any problems but there are a few
> that
> we get ODBC--call failed. This is not happening on all of our workstation
> and on one it worked the first time but when I went back to do it again it
> failed.
>
> I am guessing a possible timeout issue/settting but not for sure.
>
> --
> Thanks