Connection Not Working Properly

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
[email protected]

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

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

Like as
openconnection

Code:

---

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
[email protected]

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.