Access 2010: Link to DBF via VBA / ADO

Hi! Problem:

I have been linking programmatically to DBF files for 15+ years in different Access versions (currently 2010) OK. The client outputs the DBF files via R:BASE . . . previously DOS version, now upgraded to a Windows version.

I can link to the "new" DBF tables "manually" via LinkedTableManager OK (dBase III) in Access. The "old" tables show DOS field names: ALL CAPS, truncated to 8 chars. The "new" tables show Windows field names: extended length, mixed case, etc.

I programmatically build the connection string the same way as always, including: tblADOX.Properties("Jet OLEDB:Link Datasource") = strPath tblADOX.Properties("Jet OLEDB:Link Provider String") = "Dbase III" and it throws off err.number = -2147467259 upon catADOX.Tables.Append tblADOX

This is obviously VBA code. I have set the references to the most recent Microsoft ActiveX Data Objects (6.1 Library) I can find, but still get the same error. I also now understand that ACE has replaced JET but a straight substitution of "ACE" for "Jet" bombs immediately (err.number = 3265) and that is all I know.

Thanks in advance!

0
edit delete
are you sure?
asked Rich Todd

0 answers

Post an answer but please login first

Post Answer
  1. Please login to post answer

Similar Questions

Tagsfor this question

Forumall questions