opening file with .ben extention registry edit did not fix problem

[jebushatescats]

Hello all

I have a program that opens a file with the extention of .ben
When it trys to open the file it dies on the following code
cn1.Open _
"Driver={Microsoft Text Driver (*.txt; *.csv};" & _
"Dbq=" & sPath & ";" & _
"Extensions=asc,csv,tab,txt,ben"

I changed the following registry settings by adding ben
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Text
DisabledExtensions and Extensions
to look like this
!txt,csv,tab,asc,htm,html,ben
and
txt,csv,tab,asc,ben

and still get the following msg when I try to open the file

Data source name notr found and no default driver found

Anythin I have read o nthe subject says editting the registry should fix this problem, but not in my case.

Any thoughts?

 

[JerryKlmns]

How about

Name FileName & ".ben" As FileName & ".txt"

a simple VB statement...

 

[jebushatescats]

Jerry I am tempted to do just that, but I didn't write the app and I will get my wrists slapped for putting in that kind of work around.
I have spoken to other developers here and they are not having a problem after teh registry 'fix'. Makes we wonder whats up with my installation.

Thanks for the reply

 

[BobRodes]

Did you find this one?

http://support.microsoft.com/kb/239471

Makes me think there's something fishy in your string, or possibly that you haven't got an up to date service pack.

HTH

Bob