Novice question

• • Reply

  19 years ago

  by JPD

  JPD

  , United States

  Joined 19 years ago

  Alright, I'm really a beginner.  I can program with databases in VB, but I have no clue how to do so over the internet or what I would even need to learn to do so.  Could someone help me out?  All I need to know is what functions, etc. I should be looking at.  I wanted to locate an Access database on the web and have the VB program pull a few records out in the begining and then save them at the end.  Thanks.
  

  
  -JD

  Report abuse
• • Reply

  18 years ago

  by tlkelley

  Super Tal

  Montgomery, United States

  Joined 19 years ago

  You may want to try connecting to the database through ADO.
  This is how I connect to an Access DB through an ASP page:
  

  
  Function DBConnect(strDBName)
   Set DBConnect = Server.CreateObject("ADODB.Connection")
   path = Server.MapPath("/") + "\relative_path\" & strDBName
   DBConnect.Open "Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & path
  End Function
  

  
  Set ConnSQL = DBConnect("db_name.mdb")
  

  
  

  
  It may be similar through your VB program.
  

  Report abuse