Unix Technical Forum

Access SQL Server problem

This is a discussion on Access SQL Server problem within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I have a sporadic problem with an Access-SQL connection. Occasionally, I will get an SQL Server error of "invalid ...


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:32 PM
Mike Brown
 
Posts: n/a
Default Access SQL Server problem

I have a sporadic problem with an Access-SQL connection.
Occasionally, I will get an SQL Server error of "invalid locator
de-referenced #7143."
I can't even find the slightest hint that anyone has ever recieved this
error before.
I am using Access 2000 SP3 and SQL Small Business version 2000.

Thanks


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-27-2008, 08:32 PM
Mary Chipman
 
Posts: n/a
Default Re: Access SQL Server problem

I don't know either -- did you try a google groups search? Maybe
something will turn up there. That being said, you'd be well advised
to upgrade to a more recent version of Access. v2000 had a lot of bugs
with SQLS integration, many of which are fixed in 2002 and 2003.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Wed, 22 Oct 2003 20:34:15 -0400, "Mike Brown" <mbrown@ifs-usa.com>
wrote:

>I have a sporadic problem with an Access-SQL connection.
>Occasionally, I will get an SQL Server error of "invalid locator
>de-referenced #7143."
>I can't even find the slightest hint that anyone has ever recieved this
>error before.
>I am using Access 2000 SP3 and SQL Small Business version 2000.
>
>Thanks
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 03:56 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com