hi guys i am want to learn how to make a windows form(windows applicaiton) using visual basic that can insert data in to sql server 2000 database. I be happy if some one tell me how to write the code and complie it . i want the final product be .exe.Thanks

Use VB.
Use C.

You cannot do what you are trying to do with VBA.

Access does have a distributable .EXE that allows you to write an Access .MDB, then run it with the distributable runtime .EXE. It is a copy of Access with certain features disabled.