Suggestions for a generic user database and app

[Rich Palarea]

I'm abandoning my prevoius attempt at a salesforce automation (think lite
verions of Salesforce.com or ACT! for the web) application and looking for
either canned .ASP code or some simple guidance on building one. The pages I
built are working for creating accounts, but I can't figure out how to send
the logged in user session variable to the database to just retrieve their
records or enter new records. Should be simple via a cookie or other
session variable... Since I'm starting over, here are my requirements. Can
someone propose an easier way of doing this instead of re-inventing the
wheel?

I have Access and .ASP working on my server.

1. Each salesperson has an account (create & edit profile)
2. Each salesperson can enter and update their own leads
3. All salespeople can see leads in the system and various notes and
status, preventing disagreements, territory disputes, etc. The system will
also allow salespeople to leverage other leads with complimentary info
(dashboard view so when they are on a call they can query data and use
phrases like "We just did this project with Company X").

The application will be the foundation for a larger extranet, since my
salesforce are all independent contractors working around the nation.

I'm very comfortable poking around in code and figuring out what different
pieces are doing. Comfortable with Access, although I'm not sure how to
optimize it for the web world. I've been building websites for about 9
years. I own JBots and other WU products (page protect pro, etec.).

What would you suggest I do to get this project jumpstarted and built. I run
the company, so I would rather not spend a huge amount of time re-inventing
wheels that already exist...but I don't want to pay for stuff that I can do
relatively easily.

Thanks!
Rich

[TJS]

if you've been building websites for 9 years and are having trouble
retrieving data from a database then you should hire an ASP developer who
can assist


--
================================
[url]http://www.ASPkey.net/[/url]
A Resource Site for Web Developers
*Free OnLine web Tools
*Free development services
================================

"Rich Palarea" <rpalarea@comcast.net> wrote in message
news:OXKmupejDHA.688@TK2MSFTNGP10.phx.gbl...

> I'm abandoning my prevoius attempt at a salesforce automation (think lite
> verions of Salesforce.com or ACT! for the web) application and looking for
> either canned .ASP code or some simple guidance on building one. The pages

I

> built are working for creating accounts, but I can't figure out how to

send

> the logged in user session variable to the database to just retrieve their
> records or enter new records. Should be simple via a cookie or other
> session variable... Since I'm starting over, here are my requirements. Can
> someone propose an easier way of doing this instead of re-inventing the
> wheel?
>
> I have Access and .ASP working on my server.
>
> 1. Each salesperson has an account (create & edit profile)
> 2. Each salesperson can enter and update their own leads
> 3. All salespeople can see leads in the system and various notes and
> status, preventing disagreements, territory disputes, etc. The system will
> also allow salespeople to leverage other leads with complimentary info
> (dashboard view so when they are on a call they can query data and use
> phrases like "We just did this project with Company X").
>
> The application will be the foundation for a larger extranet, since my
> salesforce are all independent contractors working around the nation.
>
> I'm very comfortable poking around in code and figuring out what different
> pieces are doing. Comfortable with Access, although I'm not sure how to
> optimize it for the web world. I've been building websites for about 9
> years. I own JBots and other WU products (page protect pro, etec.).
>
> What would you suggest I do to get this project jumpstarted and built. I

run

> the company, so I would rather not spend a huge amount of time

re-inventing

> wheels that already exist...but I don't want to pay for stuff that I can

do

> relatively easily.
>
> Thanks!
> Rich
>
>
>

[John Bevilaqua]

Rich,

Here are a couple of REALLY GOOD PHP, Javascript,
Linux, RedHat Systems you could either emulate or
use as is. Just depends if you want a working app to
really USE or a working 5-tiered prototype to use as an
example to write your own clone in ASP.NET

[url]http://www.anteil.com[/url] (Open Source)
[url]http://www.absolutebusy.com[/url] ($75/seat)

Here are some other names from my notes, one
of which is a sort of primitive Classic ASP
implementation, but I do not recall which one:

[url]http://www.himladeon.com[/url]
[url]http://www.stellarite.com[/url]
[url]http://www.xcelsior.com[/url]

This is the grand-daddy of them all:
[url]http://www.soffront.com[/url] but it costs over
$5,000 just to get started plus 40% of sales.

[url]http://www.relata.com[/url]
[url]http://www.intrinsic-solutions.co.uk[/url]
[url]http://www.arrowemail.com[/url] (ASP based eMail Contact Sys)
[url]http://www.stylusinc.com[/url]
[url]http://www.mediavue.com[/url]
[url]http://www.whitepajama.com[/url]

Is that enough for ya?
Good luck and good searching...





*** Sent via Developersdex [url]http://www.developersdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!