MS Access is part of Office. It does not come with Vista Home Premium. You would have to purchase one of the Office versions that includes it.

Andy

Looks like you need help starting this project not completing it. You shouldn't post anything until you actually have something started yourself.

-- Andy

Mojal --

try changing the code to

Dim conn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\somepath\mydb.mdb")

if it still doesn't work, you might have the wrong...

Two things. Use the IDE to get the correct connection string. It seems a bit long with a lot of unnecessary options for Jet Database. Then make sure you ALWAYS put your connection in a Try/Catch...

Of course you would need to change my variable names to yours, and also you may need to cast your strings from the text boxes to date data types.

Andy

Actually I just thought of an easier way.

intAge = DateDiff(DateInterval.Month, dteDateOne, dteDateTwo) / 12

This should give you the age.

Andy

Check out the books online entries for the DateDiff function and DatePart funciton.

The DateDiff will give you the number of years in between, but you'll need to use some logic to determine if the...

I've found that the easiest way to query the AD Directory is by using the Active Directory Provider for ADO. Here's the code for a console app that will give you the distinguished names for all the...