access db display results only for userid/psw

[weismana81]

Hello,

I have a database that allows local businesses to add their info to my site
for free (a link and what not). It is getting to be a little silly for me to
try to update their records when they need changes made. Is there a
reasonably simple way to asign user id's and passwords to each, then when
they login, they can only view/edit their info. I guess the easiest way to
this would be if I could some how tie it into the db interface.

I'm a realist, and I know that there is probably not going to be an easy fix
for this, but I'd be willing to pay for a system, or some custom SQL or asp.
I'm very comforatable using a db with frontpage as it is just so user
friendly. I just really don't yet fully grasp asp. Seems pretty cut and
dry, but I just can't find the time to commit to it.

I've seen several posts on this subject but none answer my question. If
someone could even just drop some links on me, I would really appreciate it.
Thanks to all.

 

[Stefan B Rusynko]

Yes ASP and the DB can handle that, but it takes some knowledge in setting up the DB (the username and pword field should be part of
their recordset) and server side coding
If you are going to try it yourself
- when they log in limit the recordset to edit to theirs and create an edit form (from their data)

You'll find a sample login script (see the DB connected one) at
http://www.asp101.com/samples/login.asp
- save their username as a session variable - say Session("User") = objRS("username")
And a DB edit at
http://www.asp101.com/samples/db_edit.asp
Just limit the update (edit query) to their record (using the username field) by changing ( in the Case Else)
strSQL = "SELECT * FROM scratch ORDER BY id;"
to
strSQL = "SELECT * FROM scratch WHERE username = " & Session("User") & " ORDER BY id;"

Contact me if you still need help




| Hello,
|
| I have a database that allows local businesses to add their info to my site
| for free (a link and what not). It is getting to be a little silly for me to
| try to update their records when they need changes made. Is there a
| reasonably simple way to asign user id's and passwords to each, then when
| they login, they can only view/edit their info. I guess the easiest way to
| this would be if I could some how tie it into the db interface.
|
| I'm a realist, and I know that there is probably not going to be an easy fix
| for this, but I'd be willing to pay for a system, or some custom SQL or asp.
| I'm very comforatable using a db with frontpage as it is just so user
| friendly. I just really don't yet fully grasp asp. Seems pretty cut and
| dry, but I just can't find the time to commit to it.
|
| I've seen several posts on this subject but none answer my question. If
| someone could even just drop some links on me, I would really appreciate it.
| Thanks to all.

 

[weismana81]

AAAAHHHH!!! It's all coming together now!!!!

I can't believe I didn't think about thier user name and psw being apart of
their recordset. This is going to answer a ton of my questions by itslef.
Also, I need to bookmark asp101.com. I don't know why I haven't already as
many of my questions from this forum have brought me to that site, and it's
full of great stuff.

Anyway, I think this should do it. Thanks for the help!