William Hindman
wdhindman at dejpolsystems.com
Tue Mar 30 09:41:38 CDT 2010
...lol ...talk about getting the cart before the horse! ...so they built a be with no link to the fe and are manually doing the linkage now ...and expect a new piece in the middle to make it all work? ...without significant changes to the existing pieces? ...I'd bail on that faster than a fat mouse on a hungry cat William -------------------------------------------------- From: "Rocky Smolin" <rockysmolin at bchacc.com> Sent: Tuesday, March 30, 2010 9:35 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Expressions > There are really three components to this - the be with the data and the > browser-based fe for the user are done. The third piece is the link > between > the two. > > Like a dating service, users enter their criteria for a physician and > receive referrals to docs the be database. At the moment that link from > input to output is manual, although, IIUC, the methods and procedures are > well defined. The current level of activity is just at the threshold of > overwhelming the ability of the staff to keep up. So they need to > automate > that link. > > As the be is in access, it probably seems logical to them to add a module > to > the be that would create a table of referrals which could then be driven > back to the user through a web-based program. The third party who is > helping to coordinate this whole thing told me that they are now thinking > of > using the Expressions Engine to do that link. > > If they go that way I will probably not do the job. So I was trying to > find > out how appropriate that alternative would be and what the strengths and > weaknesses are of the EE. > > Rocky > > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of William Hindman > Sent: Tuesday, March 30, 2010 2:09 AM > To: Access Developers discussion and problem solving > Subject: Re: [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 >> > > -- > 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 >