This Recordset is not updatable - Microsoft Access / VBA

Hi,

I am upgrading the current ms access .mdb file to a .adp with sql server back end.

I have been converted tables, forms, reports to .adp..
The tables are reflected at the server.

a)

I am unable to edit or add any records from the forms, when the data is viewable from sql server connection.

The error that's displayed on the status bar is "This recordset is not updatable"..

The file is working fine in .mdb mode.. The tables are directly editable in the sql server.. But thro forms I am unable to edit..

I checked the form properties in the "data tab"..

The "recordset type" is set to "updatable snapshot". (There are only 2 options in this property 1. snapshot 2. updatable snapshot)

"Allow Edits" Property is set to "Yes"
"Allow Deletions" Property is set to "Yes"
"Allow Additions" Property is set to "Yes"

"Data Entry" Property is set to "No" (If I set to yes I see a blank form when I run..)

Pls advice on how to get the forms working with sql server backend. Where should I change the recordset, if I have to do that, when all the above property looks fine..

b) The second problem I have is I am unable to Import the queries from .mdb to .adp.

If Stored Procedure the only way.. I have calculated fields which I am using it in the .mdb file. I am directly assigning to the "controlsource" property to the respective fields were I choose the queries for record source.. How do I do this with .adp?

If I do a import from sql server thro DTS , the .mdb queries are converted to tables and the calculated fields are not recognized, hence displaying "invalid column".

Kindly advice...

Thanks & Regards,
Ruth.

Mar 6 '07 #1

Subscribe Post Reply

5221

MMcCarthy

14,534

Expert Mod 8TB

Ruth

At a guess I would say this is a SQL Server problem and has to do with the permissions that have been set up as in INSERT, UPDATE and DELETE permissions on the tables.

Mary

Mar 6 '07 #2

ruthboaz

Ruth

At a guess I would say this is a SQL Server problem and has to do with the permissions that have been set up as in INSERT, UPDATE and DELETE permissions on the tables.

Mary

Thanks Ms. Mary..

Regards,
Ruth

Mar 7 '07 #3

MMcCarthy

14,534

Expert Mod 8TB

Thanks Ms. Mary..

Regards,
Ruth

No problems.

Mar 7 '07 #4

Similar topics

/decompile and updatable recordset

by: Henry Bloom | last post by:

Hello, I have two questions: 1. The file-size of my mdb-Database grew extremely large after having written a lot of VBA-code. I know about the /decompile-option tried it .... it did not work....

Microsoft Access / VBA

"This recordset is not updatable" - why not?

by: Martin Lacoste | last post by:

I have a very basic query that Access 2000 will not allow to be updatable. I've gone through all the situations in the help file where data cannot be updated, and I don't see that this query...

Microsoft Access / VBA

this recordset is not updatable

by: kentsoi | last post by:

i write the code as follow: when i try to edit text3's content' the message " this recordset is not updatable" is display. can anyone tell me what's wrong ??? thanks a lot...

Microsoft Access / VBA

PostGreSQL to Access Updatable recordset

by: Sim Zacks | last post by:

I have a postgresql backend with an access front end and I am trying to redefine the recordset of the form to use an ADO recordset. The problem is that the CursorType always changes to...

PostgreSQL Database

Help - "this recordset is not updatable"

by: ZRexRider | last post by:

I've been reading the newsgroups and most of the solutions for this message are simple and obvious but unfortunately don't solve my problem. I have an MS-Access 2002 ADP application that...

Microsoft Access / VBA

Updating a table from a module - Why won't this work?

by: Kosmos | last post by:

Hey guys...the following code doesn't seem to work refering to the line It says the field is not updatable...I've never updated a table from a module before so I'm not sure if I am doing this...

Microsoft Access / VBA

(ADP) form problem: "This Recordset is not updatable"

by: radio1 | last post by:

Configuration: Access 2002 and SQL Server 2000 using a .ADP Project. I would VERY MUCH appreciate anyone's input into this problem I'm having. I have a form in Access that does not permit...

Microsoft Access / VBA

Updating a row in a recordset

by: Charlie | last post by:

What properties to you set to make a SQL 2005 recordset updatable? In Access, it's Recordset.edit Recordset!FieldName=SomeValue Recordset.update Any help is appreciated.

Microsoft SQL Server

Recordset is not Updatable error when linking tables

by: RZ15 | last post by:

Hi, A coworker of mine can not link or import tables into her Access database files, whether its from the server or from her own harddrive. When she tries, she is getting the message "Recordset is...

Microsoft Access / VBA

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice