Re: Passing values to MS Access Reports via COM interop and vb.net

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Andrew,

> Two problems I have encountered thus far is with consuming a list of reports
> in the reports collection of the file. Running this query "SELECT
> MSysObjects.Name FROM MSysObjects " returns an error 'No Read permission on
> MSysObjects'. Selecting the database in access and specifically setting read
> permissions on all system tables does not fix the issue and no workgroup
> information file has ever been used on this network.
>
> The other problem I have had is not being able to get the list of report
> names from a collection through ADO commands or DAO commands.
>
DAO/ADO supply only the data, not the Access structures available in a
database. As far as I know, the only way to get a list of reports is to
automate the Access database (open the *.mdb file) then (extract from Help):

"Note To list all reports in the database, whether open or closed, enumerate
the AllReports collection of the CurrentProject object. You can then use the
Name property of each individual AccessObject object to return the name of a
report."

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

.

Relevant Pages

  • Re: SYSTEMS ENGINEER/ VAX-VMS/ CAREER POSITION
    ... System Administration and database admin from NIIT, ... salary details and generate reports and enclosures,and calculates ... Responsibilities: ... Write New programs from user requirements, Programming Changes ...
    (comp.os.vms)
  • Re: Advice needed for a growing Access 2000 project
    ... However, it turned out that quite a few of those were "leftovers" from previous releases, no longer accessible from anywhere but the database window, and, thus, no longer used. ... But that certainly isn't the _norm_ -- without any 'heroic' measures, there are routine reports of split Access DBs ... Finally, in my opinion, for "Windows apps", that is, individual-user applications, modest-sized multiuser applications, and client-server applications of any size, Dot Net does NOT "help along" any of these issues. ... The post I reference was in reference its self to the MS Access Help file under "Microsoft Access database general specifications" ...
    (comp.databases.ms-access)
  • Re: running report cause fatal error- on Win98, not XP
    ... It is actually not that difficult to crash JET with complex queries, ... another query. ... only the more complex reports cause the crash- the others do ... Then compact the database: ...
    (microsoft.public.access.reports)
  • Re: running report cause fatal error- on Win98, not XP
    ... another query. ... only the more complex reports cause the crash- the others do ... Then compact the database: ... Still in the code window, choose Compile from the Debug menu. ...
    (microsoft.public.access.reports)
  • Re: WHY
    ... As most database processing doesn't take place on Windows systems, ... >spreadsheet and copy if every month.. ... prejudiced to learn that reports aren't the only thing spreadsheets can do. ... since the number of periods over which loan payments could be made is ...
    (microsoft.public.excel)