Re: Access db interface
I think Ray Camden's Database explorer might work: http://www.coldfusionjedi.com/index.cfm/2007/9/21/Database-Explorer-Updated >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 ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292385 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Access db interface
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 > > #form.query# > > > > > 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
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 > > #form.query# > > > > 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
Re: Access db interface
Wouldn't it be better to use something like DataMgr to help you migrate your Access db to MS SQL or MySQL? Then your options open up significantly... Steve "Cutter" Blades Adobe Certified Professional Advanced Macromedia ColdFusion MX 7 Developer _ http://blog.cutterscrossing.com Scott Raley -ITC wrote: > But this appears to be something you install on the pc. I'm looking for a > web tool. > > -Original Message- > From: Jerry Barnes [mailto:[EMAIL PROTECTED] > Sent: Tuesday, October 30, 2007 6:57 AM > To: CF-Talk > Subject: Re: Access db interface > > I think aquadata studios used to connect to access. > > > > > ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292346 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
RE: Access db interface
But this appears to be something you install on the pc. I'm looking for a web tool. -Original Message- From: Jerry Barnes [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 30, 2007 6:57 AM To: CF-Talk Subject: Re: Access db interface I think aquadata studios used to connect to access. ~| ColdFusion is delivering applications solutions at at top companies around the world in government. Find out how and where now http://www.adobe.com/cfusion/showcase/index.cfm?event=finder&productID=1522&loc=en_us Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292340 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
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 #form.query# 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 > > > ~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292339 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Access db interface
says it requires CF8 and we are still on MX 7 -Original Message- From: Ryan Heldt [mailto:[EMAIL PROTECTED] Sent: Monday, October 29, 2007 5:10 PM To: CF-Talk Subject: RE: Access db interface Is this what you're looking for? http://cfdbexplorer.riaforge.org/ All you'd need to do is set up a ColdFusion DSN to your Access database. > -Original Message- > From: Scott Raley -ITC [mailto:[EMAIL PROTECTED] > Sent: Monday, October 29, 2007 3: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 > > > ~| Get involved in the latest ColdFusion discussions, product development sharing, and articles on the Adobe Labs wiki. http://labs/adobe.com/wiki/index.php/ColdFusion_8 Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292338 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
Re: Access db interface
I think aquadata studios used to connect to access. ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292312 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Access db interface
Is this what you're looking for? http://cfdbexplorer.riaforge.org/ All you'd need to do is set up a ColdFusion DSN to your Access database. > -Original Message- > From: Scott Raley -ITC [mailto:[EMAIL PROTECTED] > Sent: Monday, October 29, 2007 3: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 > > > ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292275 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
RE: Access db interface
#form.query# 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 > > > ~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:292277 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4