Re: Convert Access Application to Cold Fusion
Are you planning on keeping Access as the data repository? Back in 97 [Access 2.0/Access 95], I was involved in web-enabling an Access application and it was not an easy task. The forms included multiple controls including Access's sub-form control. The point is that these controls are going to be tough to 'convert' into CF ... without major work. Not to mention the conversion of 50 to 60 complex reports. Access does have an export to HTML and ASP, but this only works well for fairly simple applications. I did however put together a system in which web-based Access report request where handed off to Access which generated the report to a file and then the file was sent back to the browser which contained the Access Report Viewer Active-X object for viewing. Bill Reichard Willow Gold [EMAIL PROTECTED] http://www.willowgold.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Convert Access Application to Cold Fusion
actually I think access 2000 is pretty sophisticated in its web integration. haven't with too much though. but played a little, downloaded the digital dashboard stuff. way cool. e From: Ryan <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Re: Convert Access Application to Cold Fusion Date: Wed, 10 Jan 2001 10:35:33 -0600 At 10:07 1/10/01 -0600, you wrote: >My client has a complete application using an Access >Database: tables, queries, forms, reports, etc. > >Is there any "quick"way to convert the Access application >to an on line Cold Fusion application with the same forms, >reports, queries, etc? I am not looking forward to >re-writing all of the user interface information (forms and >reports) into CF. > >Thanks. When I dug in to this issue 18 months ago, it seemed like there was a way to convert access forms to ASP? Maybe you could use that tool and at least get the forms generated for you, and it might be easier to read through the ASP code and convert it to CF than to do it from scratch. Sorry I have no idea what tool can do this, Access itself may be able to do some exporting. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Access Application to Cold Fusion
Have a look at http://www.commerceblocks.com - can do it about 5 minutes Kevin Parker Manager, Web Services Service and Communication WorkCover Corporation [EMAIL PROTECTED] www.workcover.com ph: +61 8 82332548 fax: +61 8 82332000 mob: 0418 800 287 -Original Message- From: Pete Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, 11 January 2001 2:38:AM To: CF-Talk Subject: Convert Access Application to Cold Fusion My client has a complete application using an Access Database: tables, queries, forms, reports, etc. Is there any "quick"way to convert the Access application to an on line Cold Fusion application with the same forms, reports, queries, etc? I am not looking forward to re-writing all of the user interface information (forms and reports) into CF. Thanks. Pete Smith Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists This e-mail is intended for the use of the addressee only. It may contain information that is protected by legislated confidentiality and/or is legally privileged. If you are not the intended recipient you are prohibited from disseminating, distributing or copying this e-mail. Any opinion expressed in this e-mail may not necessarily be that of the WorkCover Corporation of South Australia. Although precautions have been taken, the sender cannot warrant that this e-mail or any files transmitted with it are free of viruses or any other defect. If you have received this e-mail in error, please notify the sender immediately by return e-mail and destroy the original e-mail and any copies. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Convert Access Application to Cold Fusion
Hi there, I am in the process of converting an Access application to SQL Server and Cold Fusion. I haven't found an easy way to convert. The only possible way I could think of is by porting the application into Access 2000 an exporting forms, etc. into HTML formats. John On Wed, 10 January 2001, "Pete Smith" wrote: > > My client has a complete application using an Access > Database: tables, queries, forms, reports, etc. > > Is there any "quick"way to convert the Access application > to an on line Cold Fusion application with the same forms, > reports, queries, etc? I am not looking forward to > re-writing all of the user interface information (forms and > reports) into CF. > > Thanks. > > Pete Smith > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists Visit www.cfworkshop.com Find the best deals on the web at AltaVista Shopping! http://www.shopping.altavista.com ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: Convert Access Application to Cold Fusion
I don't think you'll find an easy way. >From bitter experience, let me recommend that you not lightly accept "make a web application that works just like this" as the requirements. Even though it will be frustrating for the user, you need to get them to specify what each screen and report is supposed to do. Otherwise you will be hearing 'in this special case the Access application always did this, your version doesn't and therefore is broken' from the client indefinitely. -Original Message- From: Pete Smith [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 10, 2001 11:08 AM To: CF-Talk Subject: Convert Access Application to Cold Fusion My client has a complete application using an Access Database: tables, queries, forms, reports, etc. Is there any "quick"way to convert the Access application to an on line Cold Fusion application with the same forms, reports, queries, etc? I am not looking forward to re-writing all of the user interface information (forms and reports) into CF. Thanks. Pete Smith Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Convert Access Application to Cold Fusion
Doesnt Access2k allow you to publish all this (forms, reports) to HTML? Steve - Original Message - From: "Pete Smith" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, January 10, 2001 8:07 AM Subject: Convert Access Application to Cold Fusion > My client has a complete application using an Access > Database: tables, queries, forms, reports, etc. > > Is there any "quick"way to convert the Access application > to an on line Cold Fusion application with the same forms, > reports, queries, etc? I am not looking forward to > re-writing all of the user interface information (forms and > reports) into CF. > > Thanks. > > Pete Smith > > > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists > ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Convert Access Application to Cold Fusion
I'll second that, and would love to know the answer or maybe a utility or something like that. Michael Pete Smith wrote: > My client has a complete application using an Access > Database: tables, queries, forms, reports, etc. > > Is there any "quick"way to convert the Access application > to an on line Cold Fusion application with the same forms, > reports, queries, etc? I am not looking forward to > re-writing all of the user interface information (forms and > reports) into CF. > > Thanks. > > Pete Smith > > Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ > Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Convert Access Application to Cold Fusion
commerceblocks.com I have a generator I use, but its pretty crappy, and requires considerable effort to finish a site. Eric From: "Pete Smith" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: CF-Talk <[EMAIL PROTECTED]> Subject: Convert Access Application to Cold Fusion Date: Wed, 10 Jan 2001 10:07:39 -0600 My client has a complete application using an Access Database: tables, queries, forms, reports, etc. Is there any "quick"way to convert the Access application to an on line Cold Fusion application with the same forms, reports, queries, etc? I am not looking forward to re-writing all of the user interface information (forms and reports) into CF. Thanks. Pete Smith Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: Convert Access Application to Cold Fusion
At 10:07 1/10/01 -0600, you wrote: >My client has a complete application using an Access >Database: tables, queries, forms, reports, etc. > >Is there any "quick"way to convert the Access application >to an on line Cold Fusion application with the same forms, >reports, queries, etc? I am not looking forward to >re-writing all of the user interface information (forms and >reports) into CF. > >Thanks. When I dug in to this issue 18 months ago, it seemed like there was a way to convert access forms to ASP? Maybe you could use that tool and at least get the forms generated for you, and it might be easier to read through the ASP code and convert it to CF than to do it from scratch. Sorry I have no idea what tool can do this, Access itself may be able to do some exporting. ~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Convert Access Application to Cold Fusion
My client has a complete application using an Access Database: tables, queries, forms, reports, etc. Is there any "quick"way to convert the Access application to an on line Cold Fusion application with the same forms, reports, queries, etc? I am not looking forward to re-writing all of the user interface information (forms and reports) into CF. Thanks. Pete Smith Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists