Although I have granted select permissions on the views in my database
that
are the recordesource for reports in a visual basic application, I cannot
open the reports from the application. I get the VB error 1005 ("can't
open
recordset"). It would seem to be a permissions problem because everything
else in the app works fine except the reports that are based on views. I
haven't found anything in Books on Line that has solved the problem. The
DB
was developed in sql 2000 and the compatability level for this DB in sql
2005
is 80. I'm grateful for any help.
A little OT - Quite a rant on microsoft.public.sqlserver.olap ...SQL authentication doesn't work for SQL Server to anywhere. ... reports in ADP; but somehow it's not getting traction. ... thru in order to create forms and reports against a database. ... (microsoft.public.access.modulesdaovba)
Re: why>? ...MDB are a useful learning tool ... I used them for several years before moving to SQL.... We've got the most exciting pivotTables anywhere. ... it's each to share reports with others; copy reports; duplicate ... (microsoft.public.excel)
Re: Faircom c-Tree Server vs. Relational DBMS ... Our products were very reliable in terms of how the database...SQL was used for building and upgrading the ... to process reports that take several hours to run. ... what database tools to use) that are dictated by management... (comp.databases)
Re: View or Not Views ...SQL Server use the tempdb database to store temporary results and do the required calculations, but its a per-session "table", and you can't access or use these result directly. ... If you really want to access the database in your reports and you always access aggregated data, then create pre-aggregated tables to store the result and use these tables instead of you 500Gb table. ... (microsoft.public.sqlserver.olap)
Re: Using an MS Access Project with an OLE DB Data Source ... As far as SQL... they can create their own queries and reports.... you can link to both Oracle and SQL Server databases in the same mdb... (microsoft.public.access.externaldata)
