1 Topic by ser

  • ser
  • ser
  • Administrator
  • Offline
  • From: Staffordshire Ecological Recor
  • Registered: 24-09-2008
  • Posts: 603

Topic: Strange behaviour of Assocated Access DB

I'm have problems viewing some of my records in the associated Access database linked to the SQL Server (note this isn't the original supplied by Recorder, but a created one in Access 2010)

Viewing the REFERENCES table all is fine until I scroll down to a specific row when it immediately displays the error message "ODBC - call failed" and all the entries (included those already viewed change to '#Name?'

Closing the table view and reopening restores the data (until the same row is hit)

I have examined the row, and the previous row both in Recorder and in SQL Server and cannot see anything strange

This low priority, it just means I have to work in SQL Management Studio instead of Access (and learn some SQL)

Craig

Craig Slawson
Staffordshire Ecological Record

ser's Website

2 Reply by charliebarnes

  • charliebarnes
  • Veteran
  • Offline
  • From: Greater Lincolnshire
  • Registered: 07-09-2008
  • Posts: 1,396

Re: Strange behaviour of Assocated Access DB

Have you tried recreating the linked table?

Charlie Barnes
Information Officer
Greater Lincolnshire Nature Partnership

charliebarnes's Website

3 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Strange behaviour of Assocated Access DB

It could be that the field length has changed. Open Access and find Linked table manager which is under the External Data Tab in MS Access 2010. Find the table giving the problem  and tick in the box to the left of the table name. Click OK and it should refresh the  link.

Mike Weideli

MikeWeideli's Website