Access 2010: Link to DBF via VBA / ADO
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
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!
Connection to Access DB not working on new 2016 server.
Corporation updated my server and i started getting this error (provided from the server team): GET, /page/pages/MarketMatrix-2.asp, |236|800a0e7a|Provider_cannot_be_found._It_may_not_be_properly_installed.,0 votes0 answersJim Schwetz4 days ago
Assist with AHK to send / receive queries to MSAccess
Has or does anybody have information about working in "AHK" "Auto Hotkey" and connecting to an access database? Have found this link: https://github.com/IsNull/ahkDBA0 votes0 answersBarry Pettis1 month ago
connections not work in php
I am trying to connect an access 97 database from php, I have tried three ways methods and none works for me: $db = 'c:/VENTAS.MDB'; $odbcname = "ventas_dsn_sistema";0 votes0 answerscarlos col2 months ago
Connection String Not Working
I am new to SQL Connection strings. We recently migrated from SQL Server 2008 32 bit to SQL Server 2017 64 bit. The database I am using is an Access 2010 32 bit and we upgraded to Access 2013 32 bit. I believe the connection string that was being used for SQL Server 2008 32 bit was0 votes0 answersTheresa Draper5 months ago
Loading dbf Foxpro file from Excel VBA Project
Hi there: I’m trying to load a dbf file generated from Foxpro7 into Excel (programmatically), I don’t want to use any export/import mechanisms because the objective is to carry out this transparently for the user.0 votes1 answerKlueze6 months ago
Need connection string for Office 2019
I wrote a VB .NET program using VS17 that opens Excel files and loads the data into an Access database. For .xls files, I use the connection string: Provider=Microsoft.ACE.OLEDB.12.0;Data Source= ...;Extended Properties Excel 8.0;1 vote2 answersMark Cykowski7 months ago
Macro ne fonctionnent pas avec le runtime access
Bonjour et merci voici mon besoin j'ai un fichier excel qui me permet de gere mes contact depuis un userform dans le quel il y a des textbox et une combobox qui a pour base une table access0 votes0 answersM'chi7 months ago
Excel VBA ERROR ODBC connection failed
Hi, it is working in Excel-32 bit version, but not working in excel-64 bit. I have a linked table in ms-access which is linked to a sql server table, and when I am trying to fetch the data in excel via VBA from ms-access linked table the error message "ODBC connection failed" showing.0 votes1 answerKashif Khan8 months ago
How to read values in a particular column of DBF file in c#
How to read values in a particular column of DBF file in c# code0 votes1 answerp bimsara8 months ago
Interbase ODBC to Access with foreign characters
I have a legacy Delphi database, with an application written in Borland Pascal. It's an old system, running on a virtual XP box, since it won't run on anything newer.0 votes0 answersPete D8 months ago
- Load more posts