Re: Security Using Access with asp.net
- From: "Jan T." <MyFirstName.MyLastName@xxxxxxxxxxx>
- Date: Sat, 18 Oct 2008 16:49:34 +0200
Thank you anyway for your answer. Sounds like I am better of not using Roles
the aspx way?
May be it would work to do it the classic way like you would do it with
classic asp. That is;
checkin if we have a valid user?
Anybody else?
Jan
"Nathan Sokalski" <njsokalski@xxxxxxxxxxx> skrev i melding
news:uOj$qHxLJHA.4432@xxxxxxxxxxxxxxxxxxxxxxx
I'm not sure, because the stored procedures used are already created, and
I don't think Access supports stored procedures, since it uses the Jet
database engine. I suppose if you wanted to decompile the dlls for the
Login controls and related classes and rewrite them to not use stored
procedures you could do that, but that sounds like more work than it's
worth (and I think you'll agree). As far as being able to save the roles,
passwords, etc., yes of course it is, it just can't communicate with the
Login classes since it doesn't support stored procedures. I could be
missing some workaround, but from what I've found this is what you have to
deal with (and since Access is almost never used for commercial websites,
the Login controls probably weren't designed to work with Access).
--
Nathan Sokalski
njsokalski@xxxxxxxxxxx
http://www.nathansokalski.com/
"Jan T." <MyFirstName.MyLastName@xxxxxxxxxxx> wrote in message
news:OeS$pILLJHA.740@xxxxxxxxxxxxxxxxxxxxxxx
I am a newbie with asp.net and have downloaded Visual Web Developer 2008
Express.
Now, I see that using roles, it is possible to deny access to certain
pages. Those roles are
saved in a SQL Express 2008 database. Is it possible to use Access 2007
also to save roles
and passwords and so on?
Why I ask, is because where I have my website, I am offered SQL server
2008 database.
However, this is a much more expensive solution. There are just a few
persons that will log in to our
website, andI need a safe way to log in. I don't want anybody
unauthorized to see any information
in our database. (There will be say 5 to 10 persons loging in once a week
at the most).
Can Access 2007 do the job and we will be able to save money every month?
Thank you for your help!
Jan
.
- References:
- Security Using Access with asp.net
- From: Jan T.
- Re: Security Using Access with asp.net
- From: Nathan Sokalski
- Security Using Access with asp.net
- Prev by Date: calling function of user control hosted on web page using javascript
- Next by Date: Web Farm & Context.User
- Previous by thread: Re: Security Using Access with asp.net
- Next by thread: remote client identification
- Index(es):
Relevant Pages
|
