Showing posts with label cant. Show all posts
Showing posts with label cant. Show all posts

Wednesday, March 7, 2012

Recordset not updatable

I use MS Access Project to connect to MS-SQL 2000. Even though I login as owner of the database, I can't update my table with message 'Recordset is not updatable'.
I have no problem updating through Enterprise Manager. Someone out there. Please help me
Access needs unique index to update a table. When linking SQL tables Access may ask you to select index columns. Select the number of columns needed for an "unique index"

Saturday, February 25, 2012

records per page in ReportViewer

Hi Everyone,

I can't find this to save my life! Is there a way to set the number of records that show per page on the ReportViewer? I'd like to return more per page then returns with the default setting.

thanks,

jekerry

You have to use expressions for that purpose. Have a look at this article:

http://msdn2.microsoft.com/en-us/library/ms251668(VS.80).aspx

Look for Page Breaks section in this article.

|||

Awesome!!! Thanks!

jekerry