Posted by Erland Sommarskog on 02/05/07 22:34

Wes Groleau (groleau+news@freeshell.org) writes:
> "Obtain the latest service pack" You're right--that's not hard.
> I didn't bother to look because my predecessor said that the only
> fix was to install Access 2003. Installing a new version--or installing
> a service pack--is not something our I.S. department will do on demand.

In that case... Do a check with SELECT @@version in your SQL 2000 instance
to check that you have at least SP3. The version number should read
8.00.760 for SP3 and 8.00.2039 for SP4. If it's lower than 760, you should
insist on an upgrade.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: I don't understand this "server timeout"
• Prev in forum: Re: "ODBC--call failed" Error
• Thread view: Re: Using DTS to migrate Access ot SQL Server

[Reply to this message]