I rather say I'm Access Developer more than VB programmer.
Quite rely on Access Query By Example....
Now I try to develop a access database system which open with VB (VB2005).

By using ADO to make connect to my access database but VB 2005 give me several error message,this happened to OBLEDB as well....

What is the different between them ?? ( I read MSDE document but ...)
Can someone teach me how to use code to establish connect to MS Access ? I need to do log in username and password checking...

Any example or reference website which build MS Access Application with VB 2005 ?


Your reply will be appreciated.Thank You.

As I understand it, ADO is a wrapper for OLEDB.

Could you be more explicit about what steps you are taking, and what the result is (including the text of any errors)?

You can go into the Tools menu and click on the Connect to database option to connect to your Access database that you have created. The you just have to create a datasource to tell VB what tables, view, and queries that you want to use from this database.

Just follow the wizard.

Hope this helps.

Only two things are infinite, the universe and human stupidity, and I'm not sure about the former.
Albert Einstein
US (German-born) physicist (1879 - 1955)

if you really want help it would be necessary for you to give us the code u are currently using and the errors u are getting as Brian has said and we could just help u modify it to suit ur needs.
But it would also be great if u learn how to use the wizard since u are a beginner