Access Linking to dbf

We need help Linking Access to a dbf file.
This is just on one computer. When the user clicks on a dbf link in access that has been established from another computer we get the error message:

 "The Microsoft Jet Data Base could not find the object arcola-sec.dbf. Make sure the object exist and you spell its name and path name correctly."

We have reinstalled Office including Access and made sure all components were selected. Same results. Also we have tried to do a new link; the program can see the dbf's but when you try to open one to complete the link we get the same message.  
wpiggAsked:
Who is Participating?
 
stevbeCommented:
before you wipe the whole thing it may only be missing the drivers, check the settings in Access setup from Add/Remove programs.

Steve
0
 
stevbeCommented:
does the logged on user have the approriate permissions to the network folder this dbf file is located on?

Steve
0
 
shanesuebsahakarnCommented:
Also, are you using a UNC path or a mapped drive to establish the link? If you are using a mapped drive, does that drive exist on the erroring PC? Can the broken computer navigate to the shared network folder?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
wpiggAuthor Commented:
We are using a mapped drive that exists on the error computer. The broken computer cannot browse to the network folder due to permissions to folder above the dbf folder.
0
 
shanesuebsahakarnCommented:
Then as Steve says, that is more than likely the problem.
0
 
wpiggAuthor Commented:
The broken computer does have permissions to the folder
0
 
NestorioCommented:
What kind of dbf they are? DBase, FoxPro?
If Foxpro try selecting ODBC Databases as the file type in the linking dialog box.
0
 
wpiggAuthor Commented:
I copied the database to the C drive and still have same error. I will check permissions on local computer. And, this is a DBase program.
0
 
stevbeCommented:
"The broken computer cannot browse to the network folder due to permissions to folder above the dbf folder."

Does the same user account work on another PC?
Perhaps you need to check the Access install to make sure the dbf driver got installed... when you do Get External data is DBF listed as a File Type?

You should be able to type the full path in your Windows Explorer address and show the file ... can you?

Steve
0
 
wpiggAuthor Commented:
We moved the dbf to the C: drive and tried it with the user and other user logins; same problem. She can logon to another computer and run ok. We are cleaning the register and are going to reinstall. I guess the next thing is to re image. User has a lot of GIS stuff that will have to be reloaded but that seems to be the only thing left now. Hope it works.
0
 
wpiggAuthor Commented:
We removed Access and reinstalled making sure that all options were selected and it took this time. Thanks for all the prompt responses.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.