Access Questionssubmit your own question

I have a Microsoft Access 2019 database and have a process external to the Access database that pulls some data and processes the data to email a summary to end users in my company. The process has been running for years without a problem. A few months back the external process

Dear Community, I am using Microsoft Access ACEODBC driver v. 16.00.16827.20014 on Windows 11 and connection string: 'Driver={Microsoft Access Text Driver (*.txt, *.csv)};DBQ=path\to\tmp_dir;Extensions="asc,csv,tab,txt";'

Hello. Using vba for Access 365, I want to display a “Wait” pop up form, with some nice and relevant design, that would open at the beginning of a long code execution (takes about 1 or 2 minutes) that takes place on the main/calling form, and then close once that execution is done.

I have local .NET program with Access DB running on Windows 10 local computer. I want the DB to be on web site www.xyz.com/files/db.accdb and the local Win program will be able to read/write from/to it.

There are many questions about not being able to connect. I have done some debugging, and this is what I've found. In my Web.Config file, I provide the following connection string:

Dim con As New ADODB.Connection Dim rs As New ADODB.Recordset Dim str As String Private Sub Form_Load() con.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\School Management System\Data\vihanga.mdb;ReadWrite Security Info=False"

Upgraded from access adp to access 2013 accdb linked tables. Successfully linked the tables to sql server 2019 using SQL Server Driver 17. The database uses a module and lots of stored procedures in the Moduled, forms and reports.

Hello, I am looking for the connection string to Access 2016 or Access 365. I couldn't allow to use Microsoft.ACE.OLEDB.12.0 in my company. I tried to connect using Microsoft.ACE.OLEDB.16.0, but do not have any luck. thanks

conn.Open(("provider=Microsoft.ACE.OLEDB.12.0;Data Source=D:\QC\rendemen.accdb;Persist Security Info=False;")) Provider cannot be found. it may not be properly installed

I don't know how to write the connection string. my .mdb is access 95.... and I tried those two string string connStr = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source="+ DB_path + ";User Id=admin;Password=;";

I have a single table with multiple clients who have 2 services that need to be compared via date. One services is a MUST and the other has 5 other possibilities.

My Data Source (path and name) is saved as a Constant string in the VBA module. Is there a 'workaround' for the error message: [Microsoft] [ODBC Driver Manager] Data source name too long ?

I'm setting up new pc workstations with office 365 for business which includes Access. For year's i've been linking FoxPro database files to access accdb files.

hello. i'm trying to use tables from ms access and explore the data in excel so i want to write a code in vba excel that enables me to connect to the database in access. i searched and i found that i have to use connexion strings..

I have created one Windows Form Application using VB.Net along with MS-Access Database. Currently that Ms Access Database saved in the Project path. But i want that MS Access database in Sharepoint Shared Document folder.

Hi, I have exported data into excel file using oledb since I cannot use interop or any third party library. Here is my code ''' ''' Export datagridview's data contained in an data table to excel file

I am using asp classic and access 97 database. I am trying to connect two databases at the same time. I want to join two tables in dfifferent databases. I couldn't connect them. How can we join two tables from two databases? I will be gratefull for your help.

I have a large collection of small databases that open in Access. I am trying to open them in a vb.net application (.net framework 4.7.2) with this connection string (and variations for the many directories that contain the other database files):

I have windows 8 Trying to Connect Access 2007 from VB.Net 2012 using the ADODB Connection con.open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Temp.mdb;Persist Security Info=False;Jet OLEDB:Database Password=")

how to create dns-less connection from ms access to sqlite

I don't know if I'm in the right place. I have done everything with PHP and ODBC so far. Now I wanted to make my homepage show-like and I made it with WordPress. so far everything OK

buenas noches, tengo problemas para ingresar a mi dominio en wordpress, cuando coloco para entrar al admin me arroja un error que dice:

Hi, current environment: AccessDatabase (.mdb) file located at secured network share special domain user account has read/write permissions to this network share

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.,

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/ahkDBA

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";

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 was

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;

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 access

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.