access + dbIV

B

Bruno Köller

I have problems to read a dBase IV .dbf file using VB6 and DAO 3.6

The first approach to open the file directly fails in Line 4:

Dim DB as Database
Dim RS as Recordset
Set DB = OpenDatabase(DBPathName,false,false,"dBASE IV") 'no error
Set RS = DB.OpenRecordset("SELECT fieldname FROM
[db4file]",dbDynaset,dbReadOnly 'fails

I get runtime error 3275 - unexpected error in external databse
driver(8961). I tried different filename specifications like 'file.ext',
'file#ext', [file.ext]", and so on. No one succeeded.

Next, I attached the dbf file to an existing Access 97 mdb and can read all
records correctly using Access 97 directly (what means that there couldn't
be a password protection, f.e.). But opening via VB6 as attached table or
recordset also fails.

Could anyone tell me what I'm doing wrong?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export an Access Table as an dbase III file 8
Unexpected error from external database driver (8961) 0
Export specific fields from access to Excel 0
Error 8961 when linking/importing a dbf 1
It's working by hand, but not in Access VBA code 0
not a dBASE IV file - after access query 3
Access 2007 - cant run append query, many other errors on DbIV file 1
Creating an Access database file from a dbf (dbase) file 5

Top