921 questions with Microsoft 365 and Office | Access | Development tags

Sort by: Updated
1 answer

My MS Access can connect to Azure Synapse SQL Serverless Pool, but failed to obtain data.

I connect from local MS Access File to Azure Synapse SQL Serverless Pool. I can connect to the db, and select the table and its column, but failed after select the column and got the error above. And another error message said the process is occupied by…

Microsoft 365 and Office | Access | Development
asked 2025-10-31T04:54:56.94+00:00
Jason Wong 20 Reputation points
commented 2025-11-03T04:51:35.45+00:00
Dora-T 7,070 Reputation points Microsoft External Staff Moderator
2 answers

Query to copy distinct records - no duplicates

I need to create a query to copy ONLY DISTINCT records to a new table where the old table has many duplicates? Should I set the query to copy only the First of each field? Also how do I insure that the new table accepts only distinct re records going…

Microsoft 365 and Office | Access | Development
asked 2025-10-26T18:24:17.45+00:00
Maxine Nietz 1 Reputation point
answered 2025-10-27T13:01:43.0933333+00:00
Ken Sheridan 3,296 Reputation points
1 answer

Microsoft Access Database Engine(ACE OLE DB 12.0)

How can I download Microsoft Access Database Engine(ACE OLE DB 12.0)? And how can I equip it with my visual Studio 2022?

Microsoft 365 and Office | Access | Development
asked 2025-07-04T01:27:22.48+00:00
Mojito 5 Reputation points
commented 2025-10-26T04:01:26.11+00:00
vini Rayal 0 Reputation points
2 answers

Can I change Azure SQL Server port 1433 to a different port (Connecting externally using MS Access ODBC)

Hi, Our IT has flagged port 1433 as being high risk and has requested that we change the way we connect our Access DB to our Azure SQL server. Currently we are connecting using the standard ODBC connection string. Any ideas or information would be…

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Access | For business | Windows
asked 2024-05-16T05:19:08.68+00:00
T West 136 Reputation points
commented 2025-10-19T07:03:28.5466667+00:00
Gustav 722 Reputation points MVP
2 answers

Setting TabIndex Property in VBA No Longer Working After Recent MS Office Updates

September: After my PC installed recent MS Office updates (within the last two weeks), currently running Version 2508 Build 16.0.19127.20192 (32-bit), setting the TabIndex property is no longer behaving as expected. I have procedures, in MS Access forms,…

Microsoft 365 and Office | Access | Development
asked 2025-10-03T17:54:13.63+00:00
Eric Yevtushok 0 Reputation points
commented 2025-10-08T18:54:48.1033333+00:00
Eric Yevtushok 0 Reputation points
4 answers

How to I get my Office 2019 back. 365 has replaced it.

I own MS Office Pro 2019. 365 has now replaced it. I want 2019 back. How this happened: I volunteer with a non-profit that uses 365. In order to coordinate calendar, they gave me a 365 email account. When I activated the 365 email in 2019…

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Install, redeem, activate | For business | Windows
asked 2022-10-24T12:40:54.73+00:00
Coach Pop 6 Reputation points
edited a comment 2025-09-28T16:55:11.25+00:00
Stefan Blom 318.7K Reputation points MVP Volunteer Moderator
1 answer One of the answers was accepted by the question author.

How to fix Automation error Object is not connected to server

I have an MS Access database with a table that has an OLE Object type field. The field stores a PowerPoint slide associated with the rest of the data in the record. I have a form with a bound object frame for the OLE Object field. There is a Button on…

Microsoft 365 and Office | Access | Development
asked 2024-12-02T17:17:17.8866667+00:00
William Sessums 20 Reputation points
accepted 2025-09-26T19:48:15.8733333+00:00
William Sessums 20 Reputation points
3 answers One of the answers was accepted by the question author.

Access declare stmt issue moving from Windows 10 to 11

Hi, I have a basic Access database that is erroring on me now that it was updated to Windows 11. The error message is Compile Error The code in this project must be updated for use on 64-bit systems. Please review and update Declare statements and then…

Microsoft 365 and Office | Access | Development
asked 2025-09-24T22:44:15.5566667+00:00
Eileen T 40 Reputation points
answered 2025-09-24T23:35:54.47+00:00
Eileen T 40 Reputation points
7 answers One of the answers was accepted by the question author.

TransferDatabase help

I have a MS Database that when I close the database, I want to export the main data table to a back-up database. Here is my VBA script - destfilename = "PGA Matrix 6-2022 - REP VERSION.mdb" destfileloc =…

Microsoft 365 and Office | Access | Development
Developer technologies | Visual Basic for Applications
asked 2022-06-13T19:33:04.44+00:00
Michael Moore 21 Reputation points
commented 2025-09-12T11:25:04.5566667+00:00
Moore, Mike [EMR/MSOL/HSTN] 0 Reputation points
4 answers One of the answers was accepted by the question author.

Eorris when Using Chinese characters in sql queries in ACCESS Database.

Hi, from June, the access sql will pop up error as below, when referencing any Chinese character as the screen shot. The exact same codes worked well in May.

Microsoft 365 and Office | Access | Development
asked 2025-06-16T01:40:35.5666667+00:00
Xiaoyu Wang 20 Reputation points
commented 2025-09-03T06:31:08.22+00:00
Dora-T 7,070 Reputation points Microsoft External Staff Moderator
2 answers

Microsoft Access Database Engine 2016 Redistributable (64-bit)

Microsoft Access Database Engine 2016 Redistributable (64-bit) have end of life in the end of October 2025 and it not have windows server 2016 support : Supported Operating Systems Windows 10, Windows Server 2012 R2, Windows Server 2008 R2, Windows…

Microsoft 365 and Office | Access | Development
asked 2025-08-24T12:56:54.8+00:00
רומן פרייץ 0 Reputation points
commented 2025-08-29T01:35:11.13+00:00
Teddie-D 7,100 Reputation points Microsoft External Staff Moderator
3 answers

Import named TABLES (not RANGES) from Excel to Access

So I've referenced this issue several years ago access-2016-import-from-excel-2016-table-names-do-not-show-up) I have not been able to Google anything new on this topic so I thought I'd try to bring it up again to see if there is any new information.…

Microsoft 365 and Office | Access | Development
Microsoft 365 and Office | Excel | For business | Windows
asked 2022-11-09T18:43:39.953+00:00
Dom 951 Reputation points
commented 2025-08-28T13:44:50.3366667+00:00
George Hepworth 22,090 Reputation points Volunteer Moderator
3 answers

Microsoft Access - My report is only showing up as a half page vertical

Every time I go to run my report, it shows up as a half page vertical. Can anyone provide me with step by step instructions on how to correct this? I cannot figure out how to get the report to show up and save as a full page.

Microsoft 365 and Office | Access | Development
asked 2025-06-06T13:00:51.8333333+00:00
JM2025 0 Reputation points
commented 2025-08-12T14:03:01.5166667+00:00
George Hepworth 22,090 Reputation points Volunteer Moderator
2 answers

Link MS Access to Visual Studio Code with Custom made plug in

Hello, I'm exploring the possibilities of connecting MS Access , the VBA backend of the application , with VS Code. The intention would be to create modules, classes and use existing form controls from within the MS Access application in VS Code. My…

Microsoft 365 and Office | Access | Development
asked 2022-02-16T22:18:41.207+00:00
Mathias Z 1 Reputation point
commented 2025-08-12T11:37:56.0533333+00:00
Seedback 0 Reputation points
3 answers

In MSAccess 2003, how to fix the "Not responding" file open, import or link window.

On a new computer with a clean Windows 11 installation. When using MSAccess 2003 (can't confirm for Excel or Word) and trying to open anything related to the file explorer (File - Open, Save as, New, import and link), the small file explorer window hangs…

Microsoft 365 and Office | Access | Development
asked 2025-08-01T02:08:57.5233333+00:00
FD-5007 0 Reputation points
answered 2025-08-01T12:18:01.2466667+00:00
George Hepworth 22,090 Reputation points Volunteer Moderator
2 answers

How-to get RichText from LongText AppendOnly ColumnHistory()?

Is there a workaround to get the HTML-ish RFT from ColumnHistory() of a LongText field set with RichText format and AppendOnly versioning? I'm not trying to defend AppendOnly vs better solutions. Or storing HTML-ish RTF in Access. Just asking if anybody…

Microsoft 365 and Office | Access | Development
asked 2025-07-25T22:26:34.42+00:00
Dick Watson 106 Reputation points
answered 2025-07-28T15:08:40.82+00:00
DBG 11,531 Reputation points Volunteer Moderator
3 answers

how to use relative paths for access linked tables

How can I set a relative path to an external linked table

Microsoft 365 and Office | Access | Development
asked 2025-07-15T00:08:47.1966667+00:00
Dominic Raftery 0 Reputation points
commented 2025-07-18T06:25:54.89+00:00
TiNo-T 7,690 Reputation points Microsoft External Staff Moderator
3 answers One of the answers was accepted by the question author.

Update tables linked in Access using VB.NET

I have an Access DB that has linked tables to other access DBs and links to Excel spreadsheets. I would like to scan the links, using vb.net, and validate that they are pointing to the current location of the files. If not I want to change the link…

Microsoft 365 and Office | Access | Development
Developer technologies | VB
Developer technologies | VB
An object-oriented programming language developed by Microsoft that can be used in .NET.
2,906 questions
asked 2021-10-16T22:11:13.52+00:00
Don Glover 516 Reputation points
commented 2025-07-16T14:38:29.5066667+00:00
Ryan Kristoffer M. Liray 5 Reputation points
2 answers

Set country code for Microsoft 365 personal account

How to correct country code for Microsoft 365 personal account. MSAccess cannot be downloaded, because country code is incorrect

Microsoft 365 and Office | Access | Development
asked 2025-07-14T12:13:26.3733333+00:00
Arthur Read 0 Reputation points
answered 2025-07-14T12:29:03.9+00:00
George Hepworth 22,090 Reputation points Volunteer Moderator
1 answer

Access Error Handling Question

I'm using the following error handling on my forms: Private Sub Form_AfterInsert() On Error GoTo ErrHandler Me.Requery On Error GoTo 0 Exit Sub ErrHandler: MsgBox "Error " & Err.Number & " (" & Err.Description &…

Microsoft 365 and Office | Access | Development
asked 2025-07-12T19:26:20.1166667+00:00
James 65 Reputation points
answered 2025-07-12T21:25:44.2633333+00:00
Ken Sheridan 3,296 Reputation points