Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Error linking a DBF in Access

Good! I'm having a very big problem linking .dbf files in Microsoft Access: At the beginning of the year everything was going correctly, we used a very old CRM which uses these files that contain t...
AmiraBedh's avatar
AmiraBedh
Icon for Super User rankSuper User
3 years ago

I think that the upgrade of the CRM might have updated or modified the .DBF ODBC or OLEDB drivers. This might lead to an incompatibility with the older .dbf format or even conflicts with Access.
Make sure you have the latest ODBC or OLEDB drivers for .DBF files.
If possible, try installing older drivers on one of the machines and test linking.

.MDX files are index files associated with .DBF files. Sometimes, if there is corruption or if there's a version mismatch, it can cause issues.
As you mentioned, deleting the .MDX file allowed you to link some tables. This suggests some form of corruption or incompatibility with the index files.
Consider regenerating the index (if your CRM allows it) or avoid using them if possible.

The error also maybe related to memory-intensive usage. It's possible the structure or the size of the DBF file, especially when combined with indexing, is causing a resource constraint.
Try to ncrease the machine's RAM or resources, if possible..