Just remembered (I think) When you open the recordset/resultset make sure
you open it as a Dynaset (cursor type). What data access are you using?
RDO? ADO?.......
-----Original Message-----
From: Andy Ewings [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2000 16:47
To: '[EMAIL PROTECTED]'
Subject: RE: MS Access 2000 SQL Server Project Question
yeh....it's got something to do with the cursor you are using when you make
the connection to SQL....it's been a long time since I used an Access front
end to a SQL database but start investigating down these lines until you get
the solution! In the meantime I'll try to dig it out of my memory bank once
I've blown the cobwebs away!!!!
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: 16 August 2000 16:39
To: Cf-Talk
Subject: OT: MS Access 2000 SQL Server Project Question
Thought I'd see if anyone here knows the answer to this:
I am using MS Access 2000 as a front end to access a remote SQL Server
database. Every now and then when I go to update data in a table from MS
Access I get an error saying that the "recordset cannot be updated" Does
anyone know what causes this and how to get around it? I'd understand more
if it were a multitable query involved, but I am just opening ordinary
single tables and when I get that message.
Eron
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
