Hi all



I'm doing development on Win2k and Access 2000 (ASP) and all is fine. I 

tried to deploy the application yesterday onto Win NT and found that all 

write access to the MDB failed with "requires updateable cursor". I check 

all the usual stuff like permissions and the iuser account and all 

appeared okay.



I guess this a problem with the MDAC version installed onto the server. 

Has anyone got any experience of this and would be willing to share?



I would like to use the same access db (2000) on NT so I don't need to 

maintain two databases. Does this mean MDAC 2.6 



Any words of wisdom would be gratefully received.



Regards

Graham

Yes, make sure you have MDAC 2.5 or above installed, and that JET 4.0 drivers

are available (the jet drivers do not come with MDAC any longer...)



-- Tomm



> -----Original Message-----

> From: gbrown@c... [mailto:gbrown@c...]

> Sent: Wednesday, October 24, 2001 9:57 AM

> To: ASP Databases

> Subject: [asp_databases] Query requires updateable recordset

>

>

> Hi all

>

> I'm doing development on Win2k and Access 2000 (ASP) and all is fine. I

> tried to deploy the application yesterday onto Win NT and found that all

> write access to the MDB failed with "requires updateable cursor". I check

> all the usual stuff like permissions and the iuser account and all

> appeared okay.

>

> I guess this a problem with the MDAC version installed onto the server.

> Has anyone got any experience of this and would be willing to share?

>

> I would like to use the same access db (2000) on NT so I don't need to

> maintain two databases. Does this mean MDAC 2.6

>

> Any words of wisdom would be gratefully received.

>

> Regards

> Graham