Robert Gracie
Subscriptions at servicexp.com
Thu Jan 15 19:05:47 CST 2004
Ok, the concept would be much like that of a split db. The BE being only used for data and the front end only for FE Objects such as forms, queries ..etc. I would like to take that one step further and break off the reports into a referenced mdb, separate from the FE and BE mainly because it is difficult to use an Unsecured "Report db" to pull the data from a secured BE. The problem is, the my market demographic that I want to capture for use of a program requires the flexibility of some key forms (that are generated from with-in the "host" mdb) to be user formatable so as to suit his or her business needs. As you know you can't do this in a mde. And I've come to realize no matter how thorough you lock down an mdb, it can be easily hacked... I guess the model would be much like that of Crystal Reports... I think...:-) Robert Gracie www.servicexp.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Charlotte Foust Sent: Thursday, January 15, 2004 7:24 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Reporting Question I'm not sure I understand the concept. How can you build reports independent of data structure? Anyhow Access reports don't even *have* an exposed recordset property until AXP, and then there are some limitations associated with its use. Charlotte Foust -----Original Message----- From: Robert Gracie [mailto:Subscriptions at servicexp.com] Sent: Thursday, January 15, 2004 4:08 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] Reporting Question So is my idea all "Wet", is it not possible, is it too difficult, is it just plain dumb.....? Robert Gracie www.servicexp.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Robert Gracie Sent: Wednesday, January 14, 2004 11:26 PM To: Access Developers discussion and problem solving Subject: [AccessD] Reporting Question Hello All, Is there a way to make use of a report that is located in a an external mdb and provide that report with a recordset, or an array. Bottom line is I would like to have a "report library" that is not tied to any data structure and reference that mdb in other projects. I can do everything with the exception of providing the recordset for the report from an un-linked data structure.. Preferably in A2K but open to AXP Any ideas...? Thanks! Robert Gracie www.servicexp.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com