Unix Technical Forum

Fields marked as #NAME?

This is a discussion on Fields marked as #NAME? within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Hello I have an application in Access 2000 as frontend and SQL Server 2000 as backend (linked tables with ...


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:14 PM
Walter Limacher
 
Posts: n/a
Default Fields marked as #NAME?

Hello

I have an application in Access 2000 as frontend and SQL Server 2000 as
backend (linked tables with ODBC). The SQL Server DB is located on several
computers and will be replicated (merge replication).

When creating the replication, in every replicated table an additional field
ROWGUID of type uniqueidentifier will automatically be created. On some PC
the application with the replicated DB works perfectly on others all fields
in all records are marked as #NAME? after entering a new record. When
closing and reopening the table, the data are shown correctly.

I already had a similar problem descriped in the Microsoft Knowledge Base
Article 253837 (ACC2000: #Deleted in Linked Table Containing
UniqueIndentifier): All fields were marked as #DELETED. This problem could
be solved installing the latest Service Packs. But it did not solve the
above descriped problem.

Has anybody experienced the same problem and knows how to solve it?

Thanks for your help
Walter


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:36 AM.


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