Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
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 utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Suggested Courses
Course of the Month10 days, 20 hours left to enroll

572 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