Log-in and Linking to Database

Log-in and Linking to Database - Need Help!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EMArnesen - 04 Nov 2007 14:45 GMT

There are two things I want to be able to do with my access database. The
database is called books and it has two tables: Books and students.

1) I want to be able to link to the books table and have a page read the
information about it. Such as, the page will read the books and print them to
the page and sort them by category, or have different pages for different
categories really if I need to do that.

2) I want to be able to have a log-in page that'll verify the user SN to the
password in the students database and verify it is correct so that they
log-in.

I've tried asking my professor about this, and he encourages us to just use
dreamweaver, which none of us can really get to work with us - this being
about 10 or more students. I just would like suggestions or somewhere I can
find a tutorial on how to do this, or even if there is something else I
should be trying to do to get his to work. Thanks ahead of time!

Reply to this Message

Daniel - 04 Nov 2007 15:54 GMT

1. this is a form. look in the help file or check out

http://www.functionx.com/access/Lesson24.htm
http://www.functionx.com/access/Lesson25.htm
http://www.functionx.com/access/Lesson26.htm

2. check the help on user-level security (ULS). when implemented you create
account for each user and then must authenticate user the id and password.

You mention dreamweaver which is a net dev tool not db tools??? Are you
trying to develop an online db system???

Signature

Hope this helps,

Daniel P

> There are two things I want to be able to do with my access database. The
> database is called books and it has two tables: Books and students.
[quoted text clipped - 13 lines]
> find a tutorial on how to do this, or even if there is something else I
> should be trying to do to get his to work. Thanks ahead of time!

Reply to this Message

EMArnesen - 04 Nov 2007 16:37 GMT

Yes, it's basically an on-line bookstore. We're going to make a register page
which'll send the log-in information to the stuents table of the database.
And like I said on the other, it'll verify that information when someone
tries to log-in. I am not really sure how to make the forms work with a
webpage, though I do know how to create them.

> 1. this is a form. look in the help file or check out
>
[quoted text clipped - 25 lines]
> > find a tutorial on how to do this, or even if there is something else I
> > should be trying to do to get his to work. Thanks ahead of time!

Reply to this Message

Daniel - 05 Nov 2007 12:33 GMT

Based on your needs, I would look into using MySQL and you web language of
your choice (I like PHP). I love Access and promote it profusely! However,
the web is a different story. I don't know if 2007 is better adapted for web
use (Perhaps someone else can answer that).

Now I understand why your professor mentioned dreamweaver for creating your
forms... But if he hasn't demonstrated any of this, you have a lot of work
ahead of you both in database design and in web development.

Search this forum for other posting about internet, web database, website...
and see what has been answered to them.

Signature

Hope this helps,

Daniel P

> Yes, it's basically an on-line bookstore. We're going to make a register page
> which'll send the log-in information to the stuents table of the database.
[quoted text clipped - 31 lines]
> > > find a tutorial on how to do this, or even if there is something else I
> > > should be trying to do to get his to work. Thanks ahead of time!

Reply to this Message