Adococ

• • Reply

  19 years ago

  by ReyMan

  Kyle Simmons

  Florida, United States

  Joined 19 years ago

  Alright, I have an address book program with 2 main forms, one is the specific information form, which you click a button on the main form to get to, on the main form im using a listbox and a 'adococ' active x i think its called, its in one of the windows big packs (IE common controls 6.0) but to use this adococ you have to set a speficic path thru going into it, not just setting one propertiy, ineed to know a way to make the path its looking for app.path & "\source.mdb"

  Report abuse
• • Reply

  19 years ago

  by James Crowley

  James Crowley

  London, United Kingdom

  Joined 20 years ago

  I presume what you mean is that the Connection String contains the path to the db, which you are setting at design time, and you want to be able to set it at run time. In which case, simply do something like this in form_load:
  

  
  Adodc1.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\thedb.mdb;Persist Security Info=False"
  

  
  and then connect to the db using Adodc1.Refresh

  Report abuse
• • Reply

  19 years ago

  by ReyMan

  Kyle Simmons

  Florida, United States

  Joined 19 years ago

  THANK YOU!!!!!!!!!!

  Report abuse
• • Reply

  19 years ago

  by lionking12

  lionking12

  San Diego, United States

  Joined 19 years ago

  I have a question on adobc too. Everytiime I try to add a record to the database, the new record will overwrite the first record. My code likes this
  

  
  adoCustomer.Recordset.AddNew
  

  
  Can anyone helps me? Thank you.
  

  
  

  Report abuse