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
 Other Forums
 MS Access
 SQL View Linked to MS Access

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-09-24 : 01:20:02
Sharon writes "I took an MS Access query and converted it to a SQL Server view. I have 20 unique records in this view. If I look at the view on SQL Server 2000, the view looks great. All data is present.

If I go to MS Access and link to the view, The view only shows the first record, but it repeats the first record 20 times.

Does anyone know what would cause this to happen?"
   

- Advertisement -