• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 182
  • Last Modified:

OLE DB setup. Where do I start?

I have an some dbf tables (VB 5 I think) that are a part of a custom written application.  I need to be able to setup a live connection between the dbf file and MS Outlook so I can view names and addresses and possibly edit some of the data in the fields.  The tables will need to be acessible from Outlook and my custom app at the same time.  The primary purpose is to view the data and not modify it.  Where do I start?  Is this going to be complicated?  
1 Solution
Firstly DBF files are dBase (III, V, etc) format database files and can be connected to using several methods like a DSN or using Microsoft Jet E.g

  Dim Conn: Set Conn = CreateObject("ADODB.Connection")
  Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
                   "Data Source=" & Path & ";" & _
                   "Extended Properties=""DBASE III;"";"
  Set OpenDBFConn = Conn

The best way will be for you to write an add-in to Outlook which will allow you to view the dbf files from within Outlook. I would use VB.NET or C#.  This is not that complicated and is very similar to wirting a standalone application and most of the code (database access code) will be the exact same in your Outlook app and in your standalone app.

Could you give some more information about the evnironment, what IDE you are using if any?


Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now