planner/ reminder program

[RhinoBull]

alright i've been doing some reading on using ADODB control first and for most would this help my situation?

It may but using bound controls isn't something that you would want to do on a regular basis - using ADODB library is much more flaxible way but much coding involved as well.

...second when i use it i get an "error with FROM clause" error why does this mean?

You'll need to post your code.

[dark_shadow]

the code is just establishing the connection

set Adodc = new Adodc.Connection

[RhinoBull]

I don't follow you dark: what about that "error with FROM clause" question ?

[dark_shadow]

ok i'm trying to get the basics of using the Adodc and just to understand the connection i've made a small program if it connects to the then it gives me a msgbox but when i put the code

set Adodc = new Adodc.Connection

i get a "syntax error with FROM clause"

[RhinoBull]

Take a look at this thread - we have few tutorials and samples there.

[dark_shadow]

ok thanks i appoligize for the very basic questions that are probally wasting your time

[dark_shadow]

that tutorial worked great... but now i've got another problem when i try to add a record i get a "current recordset does not support updating" at this line (higlighted in red)

rs.Open "SELECT * FROM table1", cn, adOpenDynamic, , adCmdText
  [COLOR=Red]rs.AddNew[/COLOR]     
  rs.Fields(0).Value = txttitle
  rs.Update