Convert Access Application to Cold Fusion

2001-01-10 Thread Pete Smith

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



Re: Convert Access Application to Cold Fusion

2001-01-10 Thread Ryan

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

2001-01-10 Thread Eric Dawson

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

2001-01-10 Thread Michael

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

2001-01-10 Thread Stephen M Aylor

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

2001-01-10 Thread mherbene

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

2001-01-10 Thread johnpatterson

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

2001-01-10 Thread Parker, Kevin

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

2001-01-10 Thread Eric Dawson

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

2001-01-11 Thread Wjreichard

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