[AccessD] Expressions

Rocky

"Expression Engine" is a decent web content management system, "MS 
Expression" is a Microsoft web development suite of tools targeted at the 
web site "designer" market ...neither is anything like an Access desktop fe 
nor serves the same purpose ...if the desire is to have a browser based 
fe/web app for an Access be, then the best tool for your existing skill set 
would probably be Visual Studio 2010 ...the VS 2010 Express, Web Developer 
version is free and can probably do what you need, certainly in the learning 
stage ...but the Pro version allows you to compile your code into a dll 
which meets your criteria for code security.

...assuming that the client is looking for a browser based solution on a web 
site, and anticipates high traffic, an mdb be can be problematic ...an 
Access be on the web can handle several hundred users a day quite well 
...but anything more and your client will need to move to a SQL Server be.

...either way, if you're looking at anything more than a desktop fe for 
their current mdb be, the learning curve can be quite steep ...VB.net is NOT 
vba ...it's a fe programming language for the .net framework, object 
oriented, and the web resources are quite a bit more limited than for vba or 
C#.net.

...however, Shamil and a group of AccessD developers recently did a 
conversion of the Northwind.mdb to .net and the entire project, both results 
and the interim steps to get there are hosted on codeplex and available for 
download ...it's a great learning tool that would have helped me immensely 
in my first foray into .net apps ...if you decide to take the client on, 
that would be the first place I'd look to especially since help is 
immediately available from those you already know and respect.

William

--------------------------------------------------
From: "Rocky Smolin" <rockysmolin at bchacc.com>
Sent: Tuesday, March 30, 2010 1:21 AM
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Expressions

> The BE is already Access.  The programming to be done is the process of
> connecting the patients with doctors - kind of like a medical eHarmony.
> Currently the referrals are being done manually.  So they know how to do 
> it.
> But they're ramping up so the manual approach is getting quickly
> overwhelmed.
>
> R
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Lawrence
> Sent: Monday, March 29, 2010 8:11 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] Expressions
>
> Hi Rocky:
>
> Isn't Expression a web designer type tool... it specialized in blog 
> building
> similar to WordPress. It also has a number programming features built 
> within
> it so it can be made fairly functional. OTH it is supposed to be a cruddy
> web designer not at all like my favourite Dreamweaver.
>
> I think MS Access is probably a better database management tool but it is
> not designed for web deployment. So I guess it depends on whether the
> application is to be desktop or web based.
>
> For you, the ultimate would be to quickly hack together an Access BE with
> all the business logic built in and quickly put together a custom built 
> web
> site FE and I would recommend Dreamweaver for ease of use... but that 
> would
> just be my personal opinion.
>
> The optimum would be to build the whole in something like ASP.Net or many 
> of
> the excellent frameworks that are out there.
>
> Jim
>
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
> Sent: Monday, March 29, 2010 5:10 PM
> To: 'Access Developers discussion and problem solving'
> Subject: [AccessD] Expressions
>
> A potential client is trying to decide whether to create a very 
> proprietary
> algorithm (for matching up patients with doctors - kind of a medical 
> dating
> service if you will) in Access or Expression Engine.  I don't know about
> Expression.  Good alternative?  Can you protect your code with Expression?
>
>
>
> MTIA
>
>
>
> Rocky
>
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>