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

Free dBase ODBC driver?

Hello everyone,
We are currently looking for a free dBase ODBC driver that we can use with Microsoft Access? on a Win2k3 machine. I know Windows has one built in but we are getting some strange results from it and would like to find another. Would anyone happen to know where to find one?
0
smart2009
Asked:
smart2009
  • 3
  • 2
1 Solution
 
pcelbaCommented:
At least three drivers are available from Microsoft:

Microsoft dBase Driver (*.dbf) 6.00.6001.18000  (ODBCJT32.DLL  -  Jet engine)
Microsoft dBase VFP Driver (*.dbf) 6.00.8167.00  (VFPODBC.DLL  -  comming with VFP)
Microsoft Access dBase Driver (*.dbf, *.ndx, *.mdx)  12.00.6211.1000  (ACEODBC.DLL   -  comming with Access 2007)

Probably all of them have some problems with dBase MDX indexes. What results are strange?
0
 
smart2009Author Commented:
Well this is going to sound weird but when we query something from a webpage through the ODBC we are getting what appear to be ghost records. Records that appear but if we query through MS Query with the same code the records don't show. Also In Access I am unable to link to many tables it will always say they are locked or in use. We have another computer that is using a third party (and very expensive) ODBC driver instead of window's version and it doesn't appear to have any of the problems. So I assume it's ODBC related. Purchasing another driver from that company will probably be unlikely due to cost.
0
 
pcelbaCommented:
Did you check the ODBC settings? It allows to show Deleted records and Exclusive table opening which could point to your problems.
0
 
pcelbaCommented:
0
 
smart2009Author Commented:
pcelba,
Thanks for your response to the question, it was the ODBC settings, I had the "show deleted records" checked. It appears to be working now. THANK YOU for all your help!
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

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