921 questions with Microsoft 365 and Office | Access | Development tags
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
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
	
			  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
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
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
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
	
			  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
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
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
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
	
			  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
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
	
			  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
	
			  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
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
	
			  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
	
			  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
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
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
	
			  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