Problem with underscores in names

  • Thread starter Thread starter John G
  • Start date Start date
J

John G

Using Access 2003 I am trying to link to a Paradox
database that has an underscore in it's name (ex.
prd_toysold30.db).

When I try to link to said database I get the following
error - The Microsoft Jet database engine could not find
the object 'prd_toysold30.db'. Make sure the objoect
exists and that you spell its name and the path name
correctly.

I have found that the problem is related to the
underscore in the Paradox db name. If I remove the
underscore (ex. prdtoysold30.db) then it links just
fine. However, in the production environment I cannot
remove the underscore as the Paradox db is created by an
application I have no control over. Is there another way
to get Access to link to this file or a work-around that
I'm missing?

John
 
Retraction - upon further testing it does NOT relate to
the underscore as being the problem. The problem lies in
the fact that the Paradox db does not adhere to the 8.3
naming convention.
 
Could you use VBA code to copy the file to one without an
underscore and then link to it instead of the original?
 
Back
Top