2 Login Questions

hi all!

i have two questions (and do forgive my poor grammer and spelling)

1. how can i write an "if" statement in an access db? like if i want
to search a user and if he exists do somthing and if not somthing else?

2. how can i connect the "Login Control" and "Create User
Wizard" to my db(access)? or is it something that been done automaticly as
soon as i create the control?

1. how can i write an "if" statement in an access db? like if i want
to search a user and if he exists do somthing and if not somthing else?

Select the count of the records with a specific criteria.  If the count is
greater than zero you know it exists.

2. how can i connect the "Login Control" and "Create User
Wizard" to my db(access)? or is it something that been done automaticly as
soon as i create the control?

In order to use access with these controls you'll need to write your own
membershipprovider for access.  Look up MembershipProvider in the help files and
they have a good demo on how to do this.

Number 1 has been answered by Rob.  Do the "if" statement in your
ASP.NET code.  As far as the second questions is concerned, this should give you
a reasonable headstart:
http://imar.spaanjaars.com/QuickDocId.aspx?quickdoc=404