×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Problem linking dbf files in 2000 and newer, but works in 97?!?

Problem linking dbf files in 2000 and newer, but works in 97?!?

Problem linking dbf files in 2000 and newer, but works in 97?!?

(OP)
Ok, I have never seen this before, so hopefully someone can help me resolve it.

We have a production tracking system here at work that uses dbf and ndx files (database and index respectively). When I link the files in Access '97, it works, no problem. But in 2000 and above, I get a "The Microsoft Jet Database Engine cannot open the file <filename>. It is already opened exclusively by another user.".

Anyone seen this? Any tips? I been trying to google it all day, and nothing. I tried creating the DB in 97, then opening in 2000, 2003, or 2007 and converting, but that breaks the links. Most of the machines we need to run this on utilize Office 2003, none use 97. So I cant just leave it in 97.

RE: Problem linking dbf files in 2000 and newer, but works in 97?!?

A couple ideas (I don't know)...

The later versions of Access may be using an updated ODBC driver that doesn't play nice with the version of files your tracking system is in.  You might have luck finding an older ODBC driver version and using it with the newer versions.

Access 2000 has more 'security features' so it may be having an issue with the file locking... does the user using Access have change permissions to the linked file?  A quick and dirty test would be to copy the database local, link Access to it and see if it works.

 

RE: Problem linking dbf files in 2000 and newer, but works in 97?!?

Oops.... Dbase is natively supported so it looks like 2003 supports versions 2 and 3....  

I also found this...

http://support.microsoft.com/kb/230125

"How to use dbase data with Access and Jet"

This to me suggests it is a version compatibility issue... maybe because of a licensing issue since MS is pointing to another vendor.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close