Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Linked Table row data hidden OR?

Author  Topic 

kevin24
Starting Member

13 Posts

Posted - 2012-01-25 : 00:37:13
Hi,

Using SQL 2008 Express.
I have a linked database with Access 2010, which I have finally got to update the associated table on SQL.
The table states it has 3054 rows but the row details do not show.
If I run a query on the table the row information shows.
I really need your help on this. Thanks.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-25 : 09:51:06
sorry didnt get you. where its not showing information? is it while querying from sql server? and are you able to see details directly from Access?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

kevin24
Starting Member

13 Posts

Posted - 2012-01-25 : 18:05:13
Hi,

I update table using access 2010. I then use linked table manager to update table in SQL 2008 express.

The table in SQL shows an additional row has been added but the data cannot be seen.
If I run a simple select * from xxx order by xx I can see the new data in the result.

Why is the data not visible in the data? Thanks


Go to Top of Page
   

- Advertisement -