msjro.dll 참조위치는 C:\Program Files\Common Files\System\ado\msjro.dllC# 버전---------------------using JRO; JetEngine jet=new JetEngine(); string current=""; jet.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + current + ";", "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=__tmp__.mdb; Jet OLEDB:Engine Type=5;"); File.Delete(current); File.Copy("__tmp__", current); --------------------..

OdbcConnection odcon;odcon=new OdbcConnection("DSN=디비명");OdbcCommand cmd;OdbcDataReader reader;odcon.Open();cmd=new OdbcCommand("select * from 테이블",odcon);reader=cmd.ExecuteReader();while(reader.Read()){ reader["필드"].Tostring()}

EDWin 연결 안될때 user 에 admin 입력하면 된다.

create table my1 ( [count] autoincrement not null primary key, [note] text null ); autoincrement : 자동증가 not null : 빈공간 없이 Primary key : 기본키