This is a multi-part message in MIME format.
--------------EA50CD5CA090F4E146C54089
Content-Type: multipart/alternative;
boundary="------------86E1E185367D836B084256AE"
--------------86E1E185367D836B084256AE
Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854";
x-mac-creator="4D4F5353"
Content-Transfer-Encoding: 7bit
Hi David,
You can certainly re-use the Access Queries, you can use the CFSTOREDPROC Tag, to call
them. I'm not sure about the reports though.
Personally, I would create an Admin System with functions that let you maintain the
data in the Access tables. These pages don't have to be very flash. And then the
front end of
the site can extract the data, utilizing the existing queries.
HTH (a little!!)
Nick
David wrote:
> Hi,
>
> I have a customer who likes to web-enable his Access database. The database
> has over 50+ queries and 100+ reports. He doesnt want anything extra, just
> web-enable it. Could anyone advise what is the best way to do it and
> maintain it in Access?
>
> Do I have to recode the queries in CF? And could I reuse the reports already
> designed in Access? or do I have to use a report generating software e.g.
> Crystal Reports? Is there a software that integrates better with CF than
> Crystal Reports?
>
> Sorry, have done a little CF work but nothing like that above.
>
> Thanks
> David
>
> ------------------------------------------------------------------------------
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
>http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
>message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
--------------86E1E185367D836B084256AE
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit
<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
Hi David,
<p>You can certainly re-use the Access Queries, you can use the CFSTOREDPROC
Tag, to call them. I'm not sure about the reports though.
<p>Personally, I would create an Admin System with functions that let you
maintain the data in the Access tables. These pages don't have to
be very flash. And then the front end of the site can extract
the data, utilizing the existing queries.
<p>HTH (a little!!)
<p>Nick
<br>
<br>
<p>David wrote:
<blockquote TYPE=CITE>Hi,
<p>I have a customer who likes to web-enable his Access database. The database
<br>has over 50+ queries and 100+ reports. He doesnt want anything extra,
just
<br>web-enable it. Could anyone advise what is the best way to do it and
<br>maintain it in Access?
<p>Do I have to recode the queries in CF? And could I reuse the reports
already
<br>designed in Access? or do I have to use a report generating software
e.g.
<br>Crystal Reports? Is there a software that integrates better with CF
than
<br>Crystal Reports?
<p>Sorry, have done a little CF work but nothing like that above.
<p>Thanks
<br>David
<p>------------------------------------------------------------------------------
<br>Archives: <a
href="http://www.mail-archive.com/[email protected]/">http://www.mail-archive.com/[email protected]/</a>
<br>To Unsubscribe visit <a
href="http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk">http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk</a>
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.</blockquote>
</html>
--------------86E1E185367D836B084256AE--
--------------EA50CD5CA090F4E146C54089
Content-Type: text/x-vcard; charset=us-ascii;
name="nickslay.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Nick Slay
Content-Disposition: attachment;
filename="nickslay.vcf"
begin:vcard
n:Slay;Nick
tel;cell:0414 810284
tel;home:02 4381 0284
tel;work:02 4381 0284
x-mozilla-html:FALSE
url:http://www.webbods.com.au
org:Webbods Pty Ltd
adr:;;PO Box 4054;Copacabana;NSW;2251;Australia
version:2.1
email;internet:[EMAIL PROTECTED]
title:Technical Director
x-mozilla-cpt:;3
fn:Nick Slay
end:vcard
--------------EA50CD5CA090F4E146C54089--
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
