Access/SQL Server

Article View: comp.databases.ms-access

Article #549

Back to comp.databases.ms-access Previous Next

#549

From: TEST TESTPOP_Server=pop.freeuk.n...
Date: Fri, 12 Jan 2001 20:21

19 lines
2596 bytes

I am running MS Access 97 with an SQL Server 7 attached Table.
I have an Access Form open based on an Access Query that shows a quantity of
records from the attached SQL Server Table.
I can update, delete and add records.
The problem is that when a Field is changed in one record several other
records have to be updated.  The Field which is updated is a number and is
part of the Primary Key.  I am using the same DAO code that worked fine in
Access when the table was an Access Table - the updates happenned and you
could see the numbers in other records change.  While the code runs fine
with the attached SQL Server Table the updates are not visible unless a
requery operation is performed which is unacceptable because of the delay
this introduces to user activity and the fact that the cursor moves to the
first record.  In addition, if I attempt to edit a record where the number
Field has been changed I get error messages and #Deleted appears in the
record Fields.
How do I resolve this problem?
I want the changes in the number Fields of other records to show immediately
and the records to be available for editing - just like when the underlying
Table was in Access.

Technical Details

Message-ID: <DCJ76.170296$eT4.13196254@nnrp3.clara.net>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!xfer13.netnews.com!netnews.com!newsfeed.icl.net!newspeer.clara.net!news.clara.net!nnrp3.clara.net.POSTED!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff0ac,e3db6de17c8debd,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10f31b,e3db6de17c8debd,start
X-Google-Attributes: gid10f31b,public
X-Google-Thread: f8db2,e3db6de17c8debd,start
X-Google-Attributes: gidf8db2,public
X-Google-Thread: 115bcb,e3db6de17c8debd,start
X-Google-Attributes: gid115bcb,public
X-Google-Thread: 1139e2,e3db6de17c8debd,start
X-Google-Attributes: gid1139e2,public
X-Google-ArrivalTime: 2001-01-12 12:20:05 PST
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!xfer13.netnews.com!netnews.com!newsfeed.icl.net!newspeer.clara.net!news.clara.net!nnrp3.clara.net.POSTED!not-for-mail
From: "TEST TESTPOP_Server=pop.freeuk.net" <testx@freeuk.com>
Newsgroups: comp.databases.ms-access,free.database.access,it.comp.database.access,microsoft.public.access.odbcclientsvr,microsoft.public.sqlserver.clients
Subject: Access/SQL Server
Lines: 21
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
Message-ID: <DCJ76.170296$eT4.13196254@nnrp3.clara.net>
Date: Fri, 12 Jan 2001 20:21:38 -0000
NNTP-Posting-Host: 212.126.156.53
X-Complaints-To: abuse@freeuk.net
X-Trace: nnrp3.clara.net 979330595 212.126.156.53 (Fri, 12 Jan 2001 20:16:35 GMT)
NNTP-Posting-Date: Fri, 12 Jan 2001 20:16:35 GMT