Linked table shows this: "#name?" Trauton 13.11.2005 23:46:03 Hi, I just created a table in Excel and exported it into Access and then the SQL server using Enterprise Manager. I can see the table and all its contents in via Enterprise Manager. However, if I look at same linked table throught the Access FE, the data displays fine, but if I start scrolling to see the remaining columns on the right, at some point all the infomation in the columns turns to this text: #name? The only way to get it back is to close and reopen the table, but if you scroll enough to the right... you get the same error. Does anyone know what is causing this and how to fix it? This is the first time I see this. Thank you! Trauton

Re: Linked table shows this: "#name?" Stefan Hoffmann <stefan.hoffmann[ at ]explido.de> 14.11.2005 08:58:58 hi, Trauton wrote: [Quoted Text] > I just created a table in Excel and exported it into Access and then the SQL > server using Enterprise Manager. I can see the table and all its contents in > via Enterprise Manager. However, if I look at same linked table throught the > Access FE, the data displays fine, but if I start scrolling to see the > remaining columns on the right, at some point all the infomation in the > columns turns to this text: #name? The only way to get it back is to close > and reopen the table, but if you scroll enough to the right... you get the > same error. Relink the table, it seems Access has an older description of the table than the server. mfG --> stefan <--

Re: Linked table shows this: "#name?" Trauton 15.11.2005 00:59:01 Hi Stefan, Thanks, you are right, outdated linking also causes this error. Upon looking at the table I realized that some of the columns in Excel contained titles with spaces; when they were converted to SQL tables these became the names for the fields and were incompatible with SQL. This caused the error message. Rookie mistake uh? Appreciate your help, Trauton "Stefan Hoffmann" wrote: [Quoted Text] > hi, > > Trauton wrote: > > I just created a table in Excel and exported it into Access and then the SQL > > server using Enterprise Manager. I can see the table and all its contents in > > via Enterprise Manager. However, if I look at same linked table throught the > > Access FE, the data displays fine, but if I start scrolling to see the > > remaining columns on the right, at some point all the infomation in the > > columns turns to this text: #name? The only way to get it back is to close > > and reopen the table, but if you scroll enough to the right... you get the > > same error. > Relink the table, it seems Access has an older description of the table > than the server. > > > mfG > --> stefan <-- >