Community discussion forum

ADO Data Control

• • Reply

  10 years ago

  by Developer Fusion Bot

  Developer Fusion Bot

  , United Kingdom

  Joined 2 years ago

  This thread is for discussions of ADO Data Control.

  Report abuse
• Advertisement

  Simply the fastest line-level profiler for .NET ever

  “The low overhead means it has minimal impact on the execution of my program”
  Mark Everest, Development Team Leader, Renault F1 Team Ltd.

  Try out the new ANTS Profiler 4 for yourself. Download your 14-day trial now

• • Reply

  6 years ago

  by Bravo 6

  Bravo Six

  Somehwere, USA, United States

  Joined 6 years ago

  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!

  Report abuse
• • Reply

  5 years ago

  by Niecole

  Niecole

  United States, United States

  Joined 6 years ago

  Gave me insight, thanks

  Report abuse
• • Reply

  4 years ago

  by kyoune

  kyoune

  mesia, United States

  Joined 4 years ago

  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
  

  Report abuse
• • Reply

  4 years ago

  by valilupu

  Valentin Lupu

  Bucharest, Romania, United States

  Joined 4 years ago

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

  Report abuse
• • Reply

  4 years ago

  by valilupu

  Valentin Lupu

  Bucharest, Romania, United States

  Joined 4 years ago

  Or not

  Report abuse
• • Reply

  3 years ago

  by Desichoro

  Desichoro

  USA, Los Angeles, United States

  Joined 3 years ago

  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

  Report abuse
• • Reply

  3 years ago

  by valilupu

  Valentin Lupu

  Bucharest, Romania, United States

  Joined 4 years ago

  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!

  Report abuse