yes yes but the person already has access reports built in to print out things a certain way that we are not looking to redevelop in web reports at this time, but we are also not looking to build an entire admin interface custom. Trying to use this solution so every night at 11pm they don't have to download the access db.
-----Original Message----- From: Russ [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 30, 2007 12:37 PM To: CF-Talk Subject: RE: Access db interface If possible, stop using access... that's so 1999. Install SQL Express 2005 (or use your host's) and then your clients can do whatever they want using the SQL Express Client. Russ > -----Original Message----- > From: Scott Raley -ITC [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 30, 2007 11:43 AM > To: CF-Talk > Subject: RE: Access db interface > > This will work if the users can produce all the sql. I'm hoping to > give them 50/50 where they can browse a table and do simple gui > updates like changing info in a certain column without having to type > out all the sql to do it. > > -----Original Message----- > From: Russ [mailto:[EMAIL PROTECTED] > Sent: Monday, October 29, 2007 5:24 PM > To: CF-Talk > Subject: RE: Access db interface > > <cfquery name="myQry" datasource="myaccessdsn"> #form.query# > </cfquery> > > <cfdump var="#myQry#"> > > That should probably do the trick. Of course it's very unsafe, and > will allow people to do anything they want to the db, which is sort of > the idea, I guess. > > Russ > > > -----Original Message----- > > From: Scott Raley -ITC [mailto:[EMAIL PROTECTED] > > Sent: Monday, October 29, 2007 4:57 PM > > To: CF-Talk > > Subject: Access db interface > > > > is there any open source "admin" style interface from CF to an MS > > access database to give access to raw tables information or a query > > window or anything of this type? > > > > Thanks > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade to ColdFusion 8 and integrate with Adobe Flex http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292356 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
