password/access db/code help

Hello, I seek guidance on how to set up an access database for the sites I design. Our employee site is what I need log-in help on. We have five store employee and one corporate employee locations which all need to be able to log-in to their own page according to where they work. I have set up a log-in page at URL - I want to record in the data base the name, email address and number of times the person comes to the site. I am sure that this is simple but the more I read the more I get confused. I was told by the hosting company that I can just put an access data base on the site and keep track. Please advise me of any direction or advise.

Thanks in advance Richard

Hi Richard,

Set up an access database with a table say you call it tr_user. In that table, have

UserID - autoincrement
FirstName - text (30 characters)
LastName - text (30 characters)
EmailAdress - text (30 characters)
Location - text (30 characters)
Username - text (10 characters)
Password - text (10 characters)
SiteVisits - number

You probably don't need to have anything on your login page other than their username and password. However, you might want to consider creating a register page so they can enter that information themselves or you can do that for them in the database.

Then follow the tutorial on this site under ASP.

http://www.devarticles.com/art/1/120

After the person logs in just write a SQL update statement to update the SiteVisits field for that user by 1.

There are more complex ways of doing this, but I think this should be sufficient for your purpose?

I guess that the reason I am not getting this is beause I am not sure how to "create a new MS SQL Server database called testdb" or Set up an access database with a table say you call it tr_user."
Is that something I start by creating a page in dreamweaver and if so is it ASP VBScript, ASP.Net C#, ASP.Net VB or what. This programming really makes me feel dumb.
Thanks in advance. Richard

Do you have access to Access?

Cause if you do, all you have to do is open up the program, click on create a blank access database, then click create and click on Create Table in Design view. Fill in the field names, name the table and you're done.

I guess I don't have it. I did a search and could not find it. I looked online and I guess I will have to buy it or contact our systems administrator to get it. Thanks for finding an answer to my first problem, creating a data base. Hard to create a database if you don't have the software, I guess. Richard

Another option is going with MySQL, an open source database, if your hosting company uses it. Would save you some money.

I talked with our systems administrator and he says we can use the SQL that we already are paying for. I have been reluclent to ask him to help because he is very busy and this should be simple for me to learn. He is going to sit down with me and work it out. I really do appreciate your reply's and thanks for your time.
Richard