Solved

Points for mdougan

Posted on 2002-04-22
3
159 Views
Last Modified: 2010-05-02
0
Comment
Question by:naqayya
3 Comments
 
LVL 3

Expert Comment

by:n_narayanan
ID: 6959873
Try indexing one field then issue update command.

Sometimes update fails if the table does not have any index. You can even create a dummy field for this and set as autonumber.

Cheers

Narayanan
0
 

Author Comment

by:naqayya
ID: 6959890
I have already got the update to work using angelIII and mdougan's solution.

Thanks anyway.
0
 
LVL 18

Accepted Solution

by:
mdougan earned 40 total points
ID: 6960605
Thanks!  Yea, sometimes I get the Client Side/Server Side cursors confused.  I know one of them is generally not updatable....
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Paint/Redraw window while dragging 16 82
VBS file using code from 2nd file (txt or vbs) 4 42
Access 2013 combo box not working 3 51
VB6 - Convert HH:MM into Decimal 8 62
Background What I'm presenting in this article is the result of 2 conditions in my work area: We have a SQL Server production environment but no development or test environment; andWe have an MS Access front end using tables in SQL Server but we a…
This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

791 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question