Linked table to view on SQL7 server does not show new record

I

Ivan Starr

Hello thanks for helping.

I am using Access 97 to connect to a view of a table on an SQL Server 7 box.
A new record was added through another user, but when the linked table to
the view was opened, it didn't show the new record. I checked from the SQL
server that the record had indeed been added. It was. However, even after
rebooting the linked table does not show the new record.

Anyone have any idea why? Your help is much appreciated.

Thanks,

Ivan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linked Table Cant Delete Record 2
Cannot insert new record into sql 2005 View from Access form 1
Unable to update a linked table 2
Add new record disabled 5
sql server linked table not accurate 7
Why won't Access assign a Primary Key ID to my linked SQL Table? 2
Autonumber on linked SQL table 5
new record in table not seen in corresponding form 13

Top