How do you put usernames in forum in Access? Please Help me?

[pacotx]

Hi,
I have been using access for quiet awhile (I learned it 2 months ago). I want to have a online business (using Dreamweaver and Access) but, I want to organize my data and I want to figure out how (when you go onto a website say target.com) to make the username and password in Access (Like when you register for an account, you put in your username, password, email address...ect. and the you make your account and then when you put in you username and password again to log into your account (I want to know how to do that)). Another thing, when the person logs into a account and wants to buy a product how do you do that in access.
Any answers can help me.
You could send me a link to a webpage that tells me how to do this stuff.
Any Tips?

 

[Smart]

You have to set up user security on your database

Tools , security, user level security wizard
when wizards first form appears click next then next then make sure all boxes are selected then click next select Full and new data users click next then click next enter a username and password,add user to the list click next
select user from list,select user group from list click next click finish

This will give you basic user security
It will create a secured.mdw file in the same folder as your database.

to open your database you will have to create a shortcut to it

create your shortcut by right clicking on your desktop select new then shortcut browse for your database click next then finish
Now right on the shortcut select properties shortcuttab and replace the target entry with

"C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" "Q:\YourFolder\Yourdbase.mdb" /WRKGRP "Q:\YourFolder\Secured.mdw"

The Crogram Files part points to where your MSAccess.exe is this varies between Access Versions

If you search for MSAccess in explorer you will be able to see the path

This should keep busy for a while