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 |
|
katarina07
Starting Member
31 Posts |
 Posted - 2004-10-15 : 09:39:17
|
| Hi,I have Access 2000 database linked to SQL Server 2000 Tables. When I open queries based on these tables within Access, each field in the query displays #Deleted. There was exactly this problem on this forum on 10/11/2002. Someone wrote that relinking/refreshing tables in Access did the trick. So I used Linked Table Manager in Access (Tools/Database Utilities) and that worked. But now, after a month, I wanted to do the same with another table (also linked from SQL Server) and this time it didn't help - there are still #Deleted values in the Access query.Why can I see one table and cannot see another within 1 Access database, when they are linked to Access in exactly the same way?Thanks, Katarina |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-10-15 : 09:48:11
|
| any time the tables change in SQL Server, you must refresh the links. chances are they changed again. Re-run your re-linking process and you'll be fine. This is why we always recommend linking only to VIEWS in your database, and never the tables. that way, tables can change but as long as the views do not change, nothing will ever break.- Jeff |
 |
|
|
katarina07
Starting Member
31 Posts |
Posted - 2004-10-18 : 08:49:08
|
| Hi Jeff,so I tried it today, because I thought the tables on SQL Server were just being updated at the time I wanted to link them to Access.My Select Query showed the same result - #Deleted,but then I tried the Crosstab query (with same tables and fields, just viewed in different way) and this worked.At this time I don't mind because I got what I wanted, but is there some reason for this?Katarina |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2004-10-18 : 10:03:22
|
| you tried what? updating the links or just opening them?- Jeff |
|
|
|
rkrosta
Starting Member
1 Post |
Posted - 2004-10-29 : 10:45:52
|
| I have also gotten the #Deleted error, only in an Access 97 to SQL 7.0 server database. I have tried all the Microsoft approved attempts at fixing the issue, but it still continues. I am inserting a row into a subtable using a one-to-many relationship. Any thoughts? |
|
|
|
snarkyfish
Starting Member
1 Post |
Posted - 2004-11-22 : 00:40:45
|
| I encountered this problem tonight.. i did some googling, and came up with a reference to it being caused by the use of the 'bigint' data type..(i had bigint as my id datatype).. apparently access doesn't like that datatype.. try changing it and see what you get. |
|
|
|
|
|
|
|
|
SQL Server Tables Linked to Access - #Deleted