snapshot Error Sql and Access

[Gostoli Emanuele]

i have another problem to submit you,
this time is not access VS AS/400, but Acess Vs Sql2000.
I have in sql's table linked in Access (XP but also 2000) linked via ODBC,
when i use a from with source type Snapshot and i apply a filter to the form
all the records returnes are locked by sql, id the source type is Dynaset
all work properly.
In Italy we say "Altro giro altro regalo".
Ciao Emanuele

 

[Matt]

what is the message in English? do you mean if the source type is dynaset
the locking issue does not happen?

 

[Alick [MSFT]]

Hi Gostoli,

Snapshot means No tables or the controls bound to their fields can be
edited, therefore, you are unable to edit it, and it appears it is locked.
If we want to edit the source, we can use Dynaset type.


Sincerely,

Alick Ye, MCSD
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.



--------------------
| From: "Gostoli Emanuele" <[email protected]>
| Subject: snapshot Error Sql and Access
| Date: Sat, 2 Aug 2003 17:17:54 +0200
| X-Tomcat-NG: microsoft.public.access.adp.sqlserver
|
| i have another problem to submit you,
| this time is not access VS AS/400, but Acess Vs Sql2000.
| I have in sql's table linked in Access (XP but also 2000) linked via ODBC,
| when i use a from with source type Snapshot and i apply a filter to the
form
| all the records returnes are locked by sql, id the source type is Dynaset
| all work properly.
| In Italy we say "Altro giro altro regalo".
| Ciao Emanuele
|
|
|