UPDATING Access records

12 Mar 2009 8:23 AM

jz

Can anyone tell me how I can allow for individual users to update their
Access db records? I am displaying these records using the FP DBRW.

Is it even possible to allow for only the user whose record is displayed to
update just their record?

This is obviously like a "profile" need I have and have no clue as to how
this can be done without a username and password. Any help is so so much
appreciated.

Thanks. -jz

12 Mar 2009 8:32 AM

Stefan B Rusynko

1) You will need to set up a member login (so they can get to only their record)
See http://support.microsoft.com/default.aspx?scid=321439
2) The you can use the DIW to allow edits of the DB (using the member user id as a criteria to limit the record to theirs)
See http://www.spiderwebwoman.com/resources/diwtipsandtricks.asp

--

_____________________________________________
SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
"Warning - Using the F1 Key will not break anything!" (-;
_____________________________________________

Show quoteHide quote

"jz" <j*@discussions.microsoft.com> wrote in message news:24C39424-27E3-4B7F-9AFC-7A5C55E32B71@microsoft.com...
| Can anyone tell me how I can allow for individual users to update their
| Access db records? I am displaying these records using the FP DBRW.
|
| Is it even possible to allow for only the user whose record is displayed to
| update just their record?
|
| This is obviously like a "profile" need I have and have no clue as to how
| this can be done without a username and password. Any help is so so much
| appreciated.
|
| Thanks. -jz

12 Mar 2009 8:48 AM

jz

Thanks much, Stefan. Looks like a ton to do for the login, but at least
there's a way. I appreciate it.

-jz

Show quoteHide quote

"Stefan B Rusynko" wrote:

> 1) You will need to set up a member login (so they can get to only their record)
> See http://support.microsoft.com/default.aspx?scid=321439
> 2) The you can use the DIW to allow edits of the DB (using the member user id as a criteria to limit the record to theirs)
> See http://www.spiderwebwoman.com/resources/diwtipsandtricks.asp
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "jz" <j*@discussions.microsoft.com> wrote in message news:24C39424-27E3-4B7F-9AFC-7A5C55E32B71@microsoft.com...
> | Can anyone tell me how I can allow for individual users to update their
> | Access db records? I am displaying these records using the FP DBRW.
> |
> | Is it even possible to allow for only the user whose record is displayed to
> | update just their record?
> |
> | This is obviously like a "profile" need I have and have no clue as to how
> | this can be done without a username and password. Any help is so so much
> | appreciated.
> |
> | Thanks. -jz
>
>
>

12 Mar 2009 9:22 AM

jz

Stefan,

There's a link out on that page and it may be the one I need.

If you wouldn't mind, can you point me to the right link, or another that
can tell me how to use this logon page with the id?

Oh and one more thing, please...the ID...I already have a db with users and
id's, but no passwords. Do you think I'll still need to crate a new db for
these users, or just add a pw field into my existing db?

I know that there are a lot of variables to try to answer this without
writing a book, but any quick points are appreciated. I did read thru the
logon guidelines and have an idea, but still open for feedback onthe above.

Thanks. -jz

Show quoteHide quote

"Stefan B Rusynko" wrote:

> 1) You will need to set up a member login (so they can get to only their record)
> See http://support.microsoft.com/default.aspx?scid=321439
> 2) The you can use the DIW to allow edits of the DB (using the member user id as a criteria to limit the record to theirs)
> See http://www.spiderwebwoman.com/resources/diwtipsandtricks.asp
>
> --
>
> _____________________________________________
> SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
> "Warning - Using the F1 Key will not break anything!" (-;
> _____________________________________________
>
>
> "jz" <j*@discussions.microsoft.com> wrote in message news:24C39424-27E3-4B7F-9AFC-7A5C55E32B71@microsoft.com...
> | Can anyone tell me how I can allow for individual users to update their
> | Access db records? I am displaying these records using the FP DBRW.
> |
> | Is it even possible to allow for only the user whose record is displayed to
> | update just their record?
> |
> | This is obviously like a "profile" need I have and have no clue as to how
> | this can be done without a username and password. Any help is so so much
> | appreciated.
> |
> | Thanks. -jz
>
>
>