Using Access file in a VB project

Posted on 2003-02-19
Medium Priority
Last Modified: 2010-05-01
Hi guys,

When using an MS Access XP database file in Visual Basic project, would it work fine in a computer that run MS Access 97 or in a computer that doesn't run MS Office at all. Ok, what about using dbf file in VB project, would the project run ok on a computer that doesn't have the DBase software installed.

Question by:HaryMary
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 12

Expert Comment

ID: 7981783
As long as you package the libraries you used with the deployment of your application. The VB deployment wizard should take care of all that for you.
LVL 43

Accepted Solution

TimCottee earned 800 total points
ID: 7981795
Indeed that is correct, if you are using DBF files then you simply need to ensure that you have a valid ODBC driver that will enable you to read/write to the dbf file. I personally use the Microsoft Visual Foxpro driver which is installed with MDAC. This may have some limitations if you are attempting to use clipper compatible indexes but otherwise should be fine. I would advise against using the straight dBase driver as this now requires the BDE (Borland Database Engine) to be installed to allow writing to the dbf file. You can read from it without but not write.

Expert Comment

ID: 8947122
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
LVL 12

Expert Comment

ID: 8948138
My recommendation, points to TimCottee. :0)

LVL 49

Expert Comment

ID: 8959640
Moderator, my recommended disposition is:

    Accept TimCottee's comment(s) as an answer.

DanRollins -- EE database cleanup volunteer

Featured Post


Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes some techniques which will make your VBA or Visual Basic Classic code easier to understand and maintain, whether by you, your replacement, or another Experts-Exchange expert.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Suggested Courses
Course of the Month9 days, 1 hour left to enroll

765 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question