Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

Err 3170: Couldn't find installable ISAM ?

Hi,
Is there a solution to above error ?

I tried Rs= Db.OpenRecordset("filename.dbf",....,"FoxPro 2.5;"), and it uses ISAM drivers to access external FP2.5 table.

The Help says the Registry automatically create the drivers location during installation. However my VB5.0 is installed in D:\ drive, is that the cause ?

Thanks,
Collin
0
collinng
Asked:
collinng
  • 2
1 Solution
 
dosylCommented:
Remove  your semicolon after FoxPro 2.5
0
 
dosylCommented:
Don't write filname .dbf. Write your path. Like this
 Set dbCli = .OpenDatabase(App.Path, True, False, "dBASE IV")
Set rstCli = dbCli.OpenRecordset("CLIENTS", dbOpenTable)
   
0
 
collinngAuthor Commented:
Your answer is genius.
Do you know in this case, whether i can use .MoveFirst, .MoveNext, .Recordcount etc. (recordset commands) ? it seems that i cannot move record pointer in a selected external table.

Thanks,
Collin


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now