I am trying to link data between a dBASE file (.dbf) and MS Access. The good news is that it is doable for Office 365 subscriptions, but the problem is that unless .dbf file's name is over 8 characters I get an error (The Microsoft Access database engine could not find the object ...).
For the record here is what I tried:
- External data --> More --> dBASE file --> Browsed to the file i want
- The file i want is on my local drive so this cannot be caused by a network access restriction
- Renaming the file to less than 8 characters works (Access links the data to a table), which is why I concluded that the cause of the problem is the file name and not something else
Problem is that the .dbf file is generated by another application and I cannot change its name as the other application becomes unusable if I do so.
So is there a way to link a .dbf to Access if its name is over 8 characters?