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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-23 : 10:38:27
|
| Jason writes "I have a table that is returning '#Deleted' in the linked table of the Database, yet when I look at the data on the SQL Server or in a form or report in the db it is the correct data.I will put up Screen Shots of the issue on:http://www.ddsppo.cc/jason/SQLthere are two screen shots.I am using SQL Server 2000 and Windows XP Pro with Office 2000.Thanks in advance.Jason V" |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-06-23 : 19:02:55
|
| Access normally does this when the contents of the table are deleted by some other means while the table or datasheet view is still open.You normally have to run a .Requery or do a right-click Remove Filter/Sort to refresh the data. Access won't automatically refresh the data. You'll need to explicitly tell it to.btw - Your interface design is very neat.... |
 |
|
|
|
|
|
Data between Access db and SQL Server