Linking dbf files (1 Viewer)

[Yochiver]

When linking to a dbf file in Access 2016; I get now (-until 10 days ago it worked fine-) the error message "A disk or network error has occurred. To continue, you must close the database and then reopen it". I get this error using ‘external data / database / dbase. If I want to create the link via VBA, I get error 3043. Relinking tables is not a problem. It is a standalone PC (wifi connection for Internet). Access 2016 Professional and Windows 10 Professional.

 

[arnelgp]

is the dbf getting updates everyday?
can you just import the data?
wifi, is the data on the network?
wifi is not best for linked tables.

 

[Yochiver]

The dbf files are still updated on regular times and new tables are created. Using external data / Database / Dbase gives the same problem when importing. I can import the data via a work around but that is not workable . They need to be linked . Linking was okay until a some days ago. The Access Database, dbf files and old application are all on the pc . There is no connection with the world. It gives the same problem when I close the network.

 

[arnelgp]

is there a way (from dbase) to export the data (as txt delimited or to xls file)?
then import/link the file from msa.

 

[Yochiver]

Thanks for your help.
Yes I can export the files, but I need to update the dbf files via access as well. So I need a direct link access-dbf.

 

[arnelgp]

can dbase also can "import"?

export the table (from dbase).
import it in access and manipulate it.
export the table (from msaccess).
import the new textfile (from dbase).

there are "other" program that can convert dbase to xls.
How to convert DBF to Excel (XLSX or XLS) in Windows 10 (thewindowsclub.com)

 

[Yochiver]

Thanks . I have that software but I really need the link. Updates , creations and deletes have to work. Re-importing into the dbf-files gives problems. .

 

[CarlettoFed]

You should attach a copy of the DBF file with a minimum of data, replacing the sensitive ones, in order to test and verify what happens.

 

[The_Doc_Man]

According to your message, this worked until 10 days ago. The first thing that comes to mind is a Windows Update that affected some driver. See if you can get into the Windows Update page and verify that an update occurred 10 days ago. If so, try to roll it back as a test.

If you cannot do a rollback, one of the suggestions I saw online for error 3043 involved using a UNC path rather than a mapped drive letter path for the linked files.

Copy UNC network path (not drive letter) for paths on mapped drives from Windows Explorer

I frequently want to share Windows network paths to files with other folks on my team via email or chat. We have a lot of mapped drives here, both ones we set up ourselves and ones set up by our IT

superuser.com

 

[Pat Hartman]

There was a period of time when Access could no longer link to .dbf files but I'm not sure what version that was. I thought it was 2013 that deprecated that feature and 2016 brought it back.

 

[Yochiver]

There was a period of time when Access could no longer link to .dbf files but I'm not sure what version that was. I thought it was 2013 that deprecated that feature and 2016 brought it back.

Yes A2016 had that possibility. I found the problem . It was one of the dbf files which was corrupt. Not easy to find (several 100 files) but it works again.
Thanks for thinking with me..