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 ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |