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 > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Download the latest ColdFusion 8 utilities including Report Builder, plug-ins for Eclipse and Dreamweaver updates. http;//www.adobe.com/cfusion/entitlement/index.cfm?e=labs%5adobecf8%5Fbeta Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292347 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
