Access stopped linking to a .csv file

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Working with several .mdb databases, I've created links to a few .csv files
that are refreshed weekly and used by these databases. Suddenly, upon
attempting to add additional links to any of the databases, Access no longer
allows me to do this. Upon clicking import external data and selecting "link
files" the link file window appears but Access becomes locked. I have to
"control-alt-delete" my way out of the program. The problem seems to be
specifc to my PC as I'm able to establish a link from a different PC. Seems
as if the link file manager function is broken. I've tried downloading an
Office patch, but no luck.

Any suggestions?
Gerry
 
Hi Gerry,

Try this. It fixes many similar problems with the importing and linking
wizards.

If the import/export wizards don't work at all, or if you get "No object
in this control" re-register ACCWIZ.DLL.

If it's one or more file formats that aren't listed, re-register the
following files
msexcl40.dll (Excel)
msxbse40.dll (dBase)
mspdox40.dll (Paradox)
mstext40.dll (Text, CSV, tab-delimited))
In Access 97, the filenames contain 35 instead of 40.

To re-register a DLL file,

1) Locate it (usually all these are in the Windows\System32 or
WINNT\System32 folder.

2) Locate the file regsvr32.exe.

3) Drag the DLL file's icon onto the regsvr32.exe icon.
 
Back
Top