by Micha » Wed, 27 Feb 2002 03:46:04
What will cause the #DELETED message to be shown in every row of an
SQL Linked table in ACCESS 2000? We can view the records in a linked
SQL table. The person at the remote site gets the #DELETED message in
every row of the table. I thought it was a driver issue, but I tried
one of our machines here that has the same SQL driver as the person at
the remote site with no problem.
As always thanks in advance.
Michael
by Greg Jone » Wed, 27 Feb 2002 05:48:36
Quote:>-----Original Message-----
>What will cause the #DELETED message to be shown in every
row of an
>SQL Linked table in ACCESS 2000? We can view the records
in a linked
>SQL table. The person at the remote site gets the
#DELETED message in
>every row of the table. I thought it was a driver issue,
but I tried
>one of our machines here that has the same SQL driver as
the person at
>the remote site with no problem.
>As always thanks in advance.
>Michael
>.
I am trying to create a view that includes 2 tables. I am trying to join
them on a field that is the primary key on table 1 and a field that is not a
primary key on table 2. I can link them fine if I go primary key to primary
key but the other way does not work. Is there a way around this or is it
just that I am a newbie and am lost?
Thanks
Steve Roberts
3. Using linked SQL tables in Access 2k
5. ASP problems with linked SQL tables in an Access mdb
7. Linking Sql Tables to another Database
9. update method (access97) fails on linked SQL Table!!!
10. Access 97 Hangs when Linking SQL Tables Through Proxy Server
11. Linking SQL tables to Access databases.
12. Link SQL Table
13. Problems linking SQL Table in Access