#Deleted in every field "Ron Hinds" <__ron__dontspamme[ at ]wedontlikespam_garageiq.com> 13.12.2005 23:21:02 I just created a new database in SQL Server with 3 tables. I then linked the tables to Access. There is data in the tables - when I do a SELECT on them in Query Analyzer I can see the data. When I open the tables in Access, #Deleted is in every field. Oddly, the record count is exactly the same as QA gives me. What could be going on here?

Re: #Deleted in every field "Rick Brandt" <rickbrandt2[ at ]hotmail.com> 14.12.2005 00:21:04 Ron Hinds wrote: [Quoted Text] > I just created a new database in SQL Server with 3 tables. I then > linked the tables to Access. There is data in the tables - when I do > a SELECT on them in Query Analyzer I can see the data. When I open > the tables in Access, #Deleted is in every field. Oddly, the record > count is exactly the same as QA gives me. What could be going on here? Add a Timestamp field to all of the tables and see if that cures it. -- I don't check the Email account attached to this message. Send instead to... RBrandt at Hunter dot com

Re: #Deleted in every field "Ron Hinds" <__ron__dontspamme[ at ]wedontlikespam_garageiq.com> 14.12.2005 00:31:56 Thanks Rick - I have one. But I just figured out the problem - I was using an IDENTITY column with a data type of bigint - A97 doesn't understand that so I changed it to int and all is well. "Rick Brandt" <rickbrandt2[ at ]hotmail.com> wrote in message news:QzJnf.28859$BZ5.836[ at ]newssvr13.news.prodigy.com... [Quoted Text] > Ron Hinds wrote: > > I just created a new database in SQL Server with 3 tables. I then > > linked the tables to Access. There is data in the tables - when I do > > a SELECT on them in Query Analyzer I can see the data. When I open > > the tables in Access, #Deleted is in every field. Oddly, the record > > count is exactly the same as QA gives me. What could be going on here? > > Add a Timestamp field to all of the tables and see if that cures it. > > -- > I don't check the Email account attached > to this message. Send instead to... > RBrandt at Hunter dot com > >

Re: #Deleted in every field "Mary Chipman [MSFT]" <mchip[ at ]online.microsoft.com> 15.12.2005 20:52:30 There's other things that can cause it, too -- see http://support.microsoft.com/default.aspx?scid=kb;en-us;128809 --Mary On Tue, 13 Dec 2005 16:31:56 -0800, "Ron Hinds" <__ron__dontspamme[ at ]wedontlikespam_garageiq.com> wrote: [Quoted Text] >Thanks Rick - I have one. But I just figured out the problem - I was using >an IDENTITY column with a data type of bigint - A97 doesn't understand that >so I changed it to int and all is well. > >"Rick Brandt" <rickbrandt2[ at ]hotmail.com> wrote in message >news:QzJnf.28859$BZ5.836[ at ]newssvr13.news.prodigy.com... >> Ron Hinds wrote: >> > I just created a new database in SQL Server with 3 tables. I then >> > linked the tables to Access. There is data in the tables - when I do >> > a SELECT on them in Query Analyzer I can see the data. When I open >> > the tables in Access, #Deleted is in every field. Oddly, the record >> > count is exactly the same as QA gives me. What could be going on here? >> >> Add a Timestamp field to all of the tables and see if that cures it. >> >> -- >> I don't check the Email account attached >> to this message. Send instead to... >> RBrandt at Hunter dot com >> >> >