New data not showing

  • Thread starter Thread starter Laura K
  • Start date Start date
L

Laura K

Hi I have a strange problem

I just upgraded to MS SQL from access and one of my tables does not show the
new data when it is added.

My database is attached to a web site. There is a table that has
information already in the rows. When that info is updated it does not show
on the site. When I look in the table the newly updated data is there. The
page does show the old data just not the new.

This worked just fine in access.

Now I am stumped.


Any suggestions?

Laura K
 
-----Original Message-----
Hi I have a strange problem

I just upgraded to MS SQL from access and one of my tables does not show the
new data when it is added.

My database is attached to a web site. There is a table that has
information already in the rows. When that info is updated it does not show
on the site. When I look in the table the newly updated data is there. The
page does show the old data just not the new.

This worked just fine in access.

Now I am stumped.


Any suggestions?

Laura K


.
iT SOUNDS LIKE YOU DO NOT HAVE A PRIMARY KEY SELECTED ON
Click to expand...
YOUR TABLES
 
Nope I was adding info to a table and then viewing it in a query. When I
upgraded the query it did not upgrade to a view but instead to a table.
This meant that the new info did not add to the view in SQL. When I changed
the query to a view it worked.

Laura K
 
Back
Top