[RESOLVED] MSAccess with VB6

How to connect Visual Basic with MS Access?
I have used vb6 with Oracle;
I have complete syntax for that?
I want manual connection i.e. not to use any ADO control on form load.

I have never worked with MS Access.
I use CNN.Excute("ANY valid SQL STATEMENT that work in SQL * PLUS in Oracle").
Could I be able to use similar syntax if I use MS ACCESS.
and How could I make my access database password protected?

I have to decide whether I use oracle or MS ACCesS as data base.
Aloso let me know How can i take data base backup.

Moved To Database Development

About :
1.MS Access connection (and others), visit ---> http://www.connectionstrings.com/
2.Password protection, use menu/database tools (can change according to access version)
3.Backup, one access database is only 1 file, you can copy or zip it

thanks for the reply