471,355 Members | 1,737 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,355 software developers and data experts.

This Recordset is not updatable

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
3 5067
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
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

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

6 posts views Thread by Henry Bloom | last post: by
reply views Thread by kentsoi | last post: by
1 post views Thread by Charlie | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.