This thread is for discussions of ADO Data Control.

IMHO - The Data Control's sole usefullnes is when you literally want to scroll the data, one record at a time.javascript:smilie('')
frown

I find it MUCH easier to roll my own ADO RS control that will search for the resocrd(s) I need...javascript:smilie('')
stick out tongue javascript:smilie('')
wink

This control should ONLY be used by total DB Newbies!!! (IMHO)javascript:smilie('')
eek!

Gave me insight, thanks

i'm using adodc to connect to access
but i'm having problem when i use the application on other pc...
it say that it cant found the database file...

i use this coding... but still the error is there...

Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = App.Path + "db1.mdb"
dcPekerja.RecordSource = "Select * from Table1;"
End Sub

i also try this code...but nothing happens...
Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = App.Path & "db1.mdb"
dcPekerja.RecordSource = "Select * from Table1;"
End Sub

dcPekerja => adodc

Well i supose you do have the database in the same directory with the application on the other computer

Or not

Hi there... I went though your code and fond one mistake...

Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = App.Path + "db1.mdb"
dcPekerja.RecordSource = "Select * from Table1;"
End Sub

You Should Have

Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = "\\db1.mdb"
dcPekerja.RecordSource = "Select * From Table1;"
End Sub

Well I think the code should look like:
Private Sub Form_Load()
dcPekerja.Visible = False
dcPekerja.ConnectionString = App.Path & "\db1.mdb"
dcPekerja.RecordSource = "Select * From Table1;"
End Sub

All you have to add is a tiny little "\" and there you have it. I suppose that you already figured it out by now but if not hope it helps. Also make sure that the database is in the same directory as the ".exe" or ".vbp"

Have fun coding!