re: This recordset is not updatable

Hi all,

I created a form that links to a view. The view joins the two tables and both of these tables are defined w/ Primary keys. But when I try to update the table is giving an error in Access form: "This recordset is not updatable".
Would anyone have an explanation for this?
I'm using AC2K and SQL Server 2K.
Thanks!You can only update columns in the view from one table with one update statement. You can only update columns if you have all of the columns in the declared PK for the table in the view.

-PatP

rdl generator

hi all
i m in need of a report definition language generator
is there anyone who can suggest some download links
or if u have it u can plss mail it to me
senzy_phil@.yahoo.comOn Sep 21, 4:46 pm, "sammy123" <u37530@.uwe> wrote:
> hi all
> i m in need of a report definition language generator
> is there anyone who can suggest some download links
> or if u have it u can plss mail it to me
> senzy_p...@.yahoo.com
Here are a couple links that provide similar functionality.
http://msdn2.microsoft.com/en-us/library/aa337503.aspx
http://www.codeproject.com/csharp/RdlProject.asp
http://www.jaspersoft.com/re_faq.html
Of course, if you create a couple of reports and then evaluate the XML
code in the files themselves, you should be able to create the RDL
files via C#.NET/VB.NET using streamreaders/streamwriters. Hope this
helps.
Regards,
Enrique Martinez
Sr. Software Consultant

rc:Linktargetpossible bug

Hi,
I have created a report that is displayed in an iframe using the
rc:Linktarget to force any links within the report to open in the same frame.
This works fine but when in this second report we click on a link it jumps
out of the frame and loads as the whole page. Now within the first report we
also specify the stylesheet to use and all subsequent reports called from a
link within the reports use the stylesheet as it seems that the rc:StyleSheet
command gets carried across automatically to all report links. It would be
very useful that if we you have set the Linktarget command that this command
would be propergated down to all subsequent reports. Therefore I was
wondering if this could be classed as a bug?
Example:
Report 1's url contains rc:Linktarget=reportframe&rc:StyleSheet=Amended
When you click on the a link to report 2 in report 1 it opens up in
reportframe with the stylesheet applied
Then when you click on a report 3 link in report 2 it uses the whole window
and places the url in the address bar of IE. This url contains the
rc:stylesheet=Amended but the rc:Linktarget is missing.We have the same issue that I posted here:
http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=b79f0b1a-d507-4904-a039-ce2603800807
We had to work around the issue by using Jump To URL and rebuilding the
report URL every time to keep our customize command in tact. It was a pain,
but it did work.
--
Gregg
"MadLawt" wrote:
> Hi,
> I have created a report that is displayed in an iframe using the
> rc:Linktarget to force any links within the report to open in the same frame.
> This works fine but when in this second report we click on a link it jumps
> out of the frame and loads as the whole page. Now within the first report we
> also specify the stylesheet to use and all subsequent reports called from a
> link within the reports use the stylesheet as it seems that the rc:StyleSheet
> command gets carried across automatically to all report links. It would be
> very useful that if we you have set the Linktarget command that this command
> would be propergated down to all subsequent reports. Therefore I was
> wondering if this could be classed as a bug?
> Example:
> Report 1's url contains rc:Linktarget=reportframe&rc:StyleSheet=Amended
> When you click on the a link to report 2 in report 1 it opens up in
> reportframe with the stylesheet applied
> Then when you click on a report 3 link in report 2 it uses the whole window
> and places the url in the address bar of IE. This url contains the
> rc:stylesheet=Amended but the rc:Linktarget is missing.|||Thanks Gregg, I did see your post, but as no one had answered it I was hoping
that someone out there could explain why the stylesheet command stays set for
subsequent reports and the linktarget does not. I was thinking that we would
have to use the jump to url as well instead of the jump to report, just means
that I will have to pass a parameter with the frame name to the report. to
say this is a pain in the backside is an understatement but we all get used
to work arounds dont we.
"Gregg" wrote:
> We have the same issue that I posted here:
> http://www.microsoft.com/technet/community/newsgroups/dgbrowser/en-us/default.mspx?dg=microsoft.public.sqlserver.reportingsvcs&mid=b79f0b1a-d507-4904-a039-ce2603800807
> We had to work around the issue by using Jump To URL and rebuilding the
> report URL every time to keep our customize command in tact. It was a pain,
> but it did work.
> --
> Gregg
>
> "MadLawt" wrote:
> > Hi,
> > I have created a report that is displayed in an iframe using the
> > rc:Linktarget to force any links within the report to open in the same frame.
> > This works fine but when in this second report we click on a link it jumps
> > out of the frame and loads as the whole page. Now within the first report we
> > also specify the stylesheet to use and all subsequent reports called from a
> > link within the reports use the stylesheet as it seems that the rc:StyleSheet
> > command gets carried across automatically to all report links. It would be
> > very useful that if we you have set the Linktarget command that this command
> > would be propergated down to all subsequent reports. Therefore I was
> > wondering if this could be classed as a bug?
> >
> > Example:
> > Report 1's url contains rc:Linktarget=reportframe&rc:StyleSheet=Amended
> > When you click on the a link to report 2 in report 1 it opens up in
> > reportframe with the stylesheet applied
> > Then when you click on a report 3 link in report 2 it uses the whole window
> > and places the url in the address bar of IE. This url contains the
> > rc:stylesheet=Amended but the rc:Linktarget is missing.