Connection Not Working Properly

[anubhava]

Dear All,
Hi I m software Developer. I m working with Database .
At the time of Retriveing Information From Database some Data are Access from the database but some data skip it. and connection is close.
My connection is created by ODBC and Access Driver.

Can u helping me.


Thanks
Anubhava Dimri
9250168195
anubhava.prodata@gmail.com

[HanneSThEGreaT]

It will help if you give us the code............

[anubhava]

When i m sending Data From One form to Other then Connection not working properly.

Like as
openconnection

sql ="Select * from School_information"
cmd = new odbc.command(sql,conn)
reader= cmd.execute
while reader.read
with frm_School
  .lbl_class  = Reader("School_name")
end with
end while

if it is using for same form then coding execute Properly.

Help ME



Thanks
Anubhava Dimri
9250168195
anubhava.prodata@gmail.com

[anubhava]

Hi

I m working for Server Application.
Is msaccess if Comfortable for Sever Type Database.
Is SQL is must for Server types Database.

Need Halp.