Storing and Retrieving Info in Access

[Erik T. Nomad]

I'm not sure if this is even the best place to ask this question, but
here goes: my site is hosted by a third party on a Win2K platform and
there is a SQL server on it. What I'd like is to be able to create a
"Wish List" of sorts on the site, whereby the user enters info on
products they want, and they can then retrieve that info the next time
they visit. Can I do this in ASP and send info to an Access DB on the
server? I'm a veteran at design but a newbie at real programming.
Thanks for your help!

E

[John Blessing]

"Erik T. Nomad" <erikthenomad@hotmail.com> wrote in message
news:f4f5a604.0406090927.6fbf22cb@posting.google.c om...

> I'm not sure if this is even the best place to ask this question, but
> here goes: my site is hosted by a third party on a Win2K platform and
> there is a SQL server on it. What I'd like is to be able to create a
> "Wish List" of sorts on the site, whereby the user enters info on
> products they want, and they can then retrieve that info the next time
> they visit. Can I do this in ASP and send info to an Access DB on the
> server? I'm a veteran at design but a newbie at real programming.
> Thanks for your help!
>
> E

Assuming you have some way of uniquely identifying them (e.g.
username/password) then yes. As you have Sql Server on this web host, why
not use that instead of an Access DB.

As to how you do it. This is akin to asking "how to do program?" Best answer
in my opinion is to buy a book on ASP database programming. The Wrox series
used to be good.


--
John Blessing

[url]http://www.LbeHelpdesk.com[/url] - Help Desk software priced to suit all
businesses
[url]http://www.room-booking-software.com[/url] - Schedule rooms & equipment bookings
for your meeting/class over the web.
[url]http://www.lbetoolbox.com[/url] - Remove Duplicates from MS Outlook

[Erik T. Nomad]

"John Blessing" <newsgroup@LbeHelpdesk.com> wrote in message news:<2ip795Fp35d0U1@uni-berlin.de>...

> "Erik T. Nomad" <erikthenomad@hotmail.com> wrote in message
> news:f4f5a604.0406090927.6fbf22cb@posting.google.c om...

> > I'm not sure if this is even the best place to ask this question, but
> > here goes: my site is hosted by a third party on a Win2K platform and
> > there is a SQL server on it. What I'd like is to be able to create a
> > "Wish List" of sorts on the site, whereby the user enters info on
> > products they want, and they can then retrieve that info the next time
> > they visit. Can I do this in ASP and send info to an Access DB on the
> > server? I'm a veteran at design but a newbie at real programming.
> > Thanks for your help!
> >
> > E

>
> Assuming you have some way of uniquely identifying them (e.g.
> username/password) then yes. As you have Sql Server on this web host, why
> not use that instead of an Access DB.
>
> As to how you do it. This is akin to asking "how to do program?" Best answer
> in my opinion is to buy a book on ASP database programming. The Wrox series
> used to be good.

Will do; didn't know if there was some pre-existing code out there
that might help me achieve this functionality (I've already added
pretty good "tell a friend" and message board functions to my site in
ASP by just modifying what's already out there), but thanks for the
first step in the right direction.

E

[Bullschmidt]

For a "quick and dirty" generic ASP open source solution to putting
databases on the Web that just requires setting up a configuration page
for each table or query and uploading the database to the Web as long as
there is an autonumber field in each table (and you'll probably also
separately want to create login capabilities), perhaps try something
like this:
GenericDB by Eli Robillard
[url]http://www.genericdb.com[/url] and then click on the Tips link to see an
example

Best regards,
J. Paul Schmidt, Freelance ASP Web Consultant
[url]http://www.Bullschmidt.com[/url]
ASP Design Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


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