357 questions with Access tags

Sort by: Updated
1 answer

Adding, Updating, and Deleting records using either OLE or SQL

I don't know how I would describe this every time I get runtime errors. What I want to know is should I use SQL or OLEDB libraries while using Visual Studio IDE? Which one works best?

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,958 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,729 questions
asked 2024-08-17T01:44:59.6366667+00:00
John 446 Reputation points
answered 2024-08-17T10:30:13.4933333+00:00
Karen Payne MVP 35,396 Reputation points
1 answer

Error Code: 53003 - Can't access my portal.azure.com

I was granted full admin on my account, yet when trying to login to portal.azure.com i get the below error: I think this is related to conditional access - but i don't have any conditional access tab on my portal - since i have entraID basic…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Microsoft Entra External ID
Microsoft Entra External ID
A modern identity solution for securing access to customer, citizen and partner-facing apps and services. It is the converged platform of Azure AD External Identities B2B and B2C. Replaces Azure Active Directory External Identities.
2,808 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
20,915 questions
asked 2024-08-16T14:28:49.48+00:00
Ben Shabat, Zahi 0 Reputation points
answered 2024-08-16T23:55:17.78+00:00
James Hamil 23,626 Reputation points Microsoft Employee
2 answers

Calculating time differences for a swimmer in Access 2019

I'm having trouble calculating time differences for a swimmer in Microsoft Access 2019. How can I do this properly?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
863 questions
asked 2024-08-15T17:15:11.9566667+00:00
Charles Johnson 0 Reputation points
edited an answer 2024-08-16T12:50:02.7466667+00:00
Ken Sheridan 2,761 Reputation points
0 answers

OleDb issue on Visual Studio

Dear Microsoft Support Team, I am reaching out to seek assistance with an issue I am encountering while trying to use the OLE DB provider on a MacBook Pro with the M3 chip, running Windows 11 through Parallels. I have been attempting to connect to a…

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,958 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
asked 2024-08-15T22:09:34.7066667+00:00
dongju kim 0 Reputation points
commented 2024-08-16T09:34:17.54+00:00
Tianyu Sun-MSFT 30,066 Reputation points Microsoft Vendor
1 answer

New admin user unable to log into Azure Portal

A new stuff who was granted access to Azure portal last week but unable to access after logging in with MFA. He has the same role assignments same as another admin user who is able to log in. he is using uw.com

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
asked 2024-08-16T08:27:09.5433333+00:00
Nana Poku 20 Reputation points
answered 2024-08-16T08:57:14.7+00:00
akinbade abiola 12,820 Reputation points
3 answers

How to fix this error: InvalidAuthenticationTokenTenant?

I have used Azure for years but recently I couldn't access my storage containers. The error message is InvalidAuthenticationTokenTenant. What should I do?

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
3,018 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
asked 2024-08-03T23:27:13.28+00:00
H Pan 0 Reputation points
commented 2024-08-15T20:00:06.64+00:00
Konstantinos Passadis 18,881 Reputation points MVP
0 answers

How to fix Access Denied error messages on MySQL Workbench

Kindly, help solve this problem. I cannot use my databases because of these error messages. I am running the MySQL Workbench on Microsoft Windows.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
asked 2024-08-13T03:10:33.59+00:00
Sam Joe Armoh 0 Reputation points
1 answer

Access Europe - Wed 7 Aug: Using Treeviews with Access Applications (Pete Poppe)

The next Access Europe User Group meeting will be on Wednesday 7 Aug 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome Pete Poppe who is very well known to on sevewral Access forums as…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,534 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,780 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
863 questions
asked 2024-08-03T12:33:52.15+00:00
Colin Riddington 141 Reputation points MVP
answered 2024-08-12T11:23:08.8733333+00:00
Colin Riddington 141 Reputation points MVP
1 answer

MS Access version 2407 unable to connect to Salesforce via Linked Table Manager

Has anyone else experienced a problem connecting to Salesforce after updating to version 2407 (Build 17830.20138) Current Channel? Issue started happening last week (7/29/2024) to user where they get error ODBC--connection to '{{Salesforce}}' failed when…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
863 questions
asked 2024-08-08T23:51:24.59+00:00
Brent Smiley 0 Reputation points
edited an answer 2024-08-09T21:58:42.68+00:00
Karl Donaubauer 1,726 Reputation points MVP
2 answers

where can I find Microsoft.ACE.OLEDB.12.0 Provider 64-bit

hello, We need the driver "Microsoft.ACE.OLEDB.12.0 Provider 64-bit", but it is no longer available! Could you provide me with a download link? Regards

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,495 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,781 questions
SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
520 questions
asked 2024-04-19T01:28:50.96+00:00
Elham Khalaji 0 Reputation points
commented 2024-08-09T15:02:09.4966667+00:00
IT Pat Egan 0 Reputation points
3 answers One of the answers was accepted by the question author.

Message Trace Option missing under Mail Flow in EAC

We are running a Hybrid Environment; we activate Global Admin access through Privilege Identity Management. We have two roles setup for users, Global Administrator & Exchange Recipient Administrator. Up until a month or so ago, I was able to run a…

Microsoft Exchange Online
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Microsoft Exchange Online Management
Microsoft Exchange Online Management
Microsoft Exchange Online: A Microsoft email and calendaring hosted service.Management: The act or process of organizing, handling, directing or controlling something.
4,428 questions
asked 2024-08-06T17:34:43.88+00:00
Mark Bovenzi 40 Reputation points
commented 2024-08-08T12:37:46.08+00:00
Mark Bovenzi 40 Reputation points
0 answers

AD FS set up on Windows Server 2022 Standard and version 10.0.20348 Build 20348 failed to go through Authentication API "Refresh_Token" grant_type

Set up a .net application which based on the following details: a) AD FS on Windows Server 2022 Standard and version 10.0.20348 Build 20348. b) Application run on Dotnet hosting bundle 6.0.21 Windows version. Errors: With PKCE Authentication…

ASP.NET Core
ASP.NET Core
A set of technologies in the .NET Framework for building web applications and XML web services.
4,456 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Active Directory Federation Services
Active Directory Federation Services
An Active Directory technology that provides single-sign-on functionality by securely sharing digital identity and entitlement rights across security and enterprise boundaries.
1,236 questions
.NET Runtime
.NET Runtime
.NET: Microsoft Technologies based on the .NET software framework.Runtime: An environment required to run apps that aren't compiled to machine language.
1,146 questions
asked 2024-08-06T11:11:18.7433333+00:00
Jade Lim 0 Reputation points
1 answer One of the answers was accepted by the question author.

how to convert *mdb file to *exe.?

Hello, I browsed different websites looking for a solution regarding the conversion of an access file but I didn't find it. My question is if it is possible to convert a file with *.mdb extension to obtain an executable *.exe file?

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,517 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,089 questions
asked 2024-07-31T12:56:10.15+00:00
claude manionga 20 Reputation points
edited the question 2024-08-06T02:03:57.1866667+00:00
Jiajing Hua-MFST 8,440 Reputation points Microsoft Vendor
0 answers

SSMA does not detect or show the tables in my access database

Hi, I am trying to migrate my database to SQL server but SSMA does not detect or show any of the tables. I have created a sample database file that has similar problem with the table foo but not with Foo1, where Foo1 is simply created by exporting Foo…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
asked 2024-08-02T08:19:58.2733333+00:00
TK 0 Reputation points
1 answer

how do i reset the admins password when im on a local user accoun

I ot a new pc since my gaming one broke and unfortunately i didnt knew the admin password and nobody knew the password and i feel so trapped when it comes to downloading important stuff and im so annoyed and sad about this situation please help me to…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
asked 2024-08-01T21:18:58.0966667+00:00
barney murray 0 Reputation points
commented 2024-08-02T07:45:22.55+00:00
1 answer One of the answers was accepted by the question author.

Best way to sort and reduce data in an Access MDB table

Looking for some advice on handling a table. I’ve got an Access mdb database. The VB program that drives it  puts data into two columns of a table, and for each row it puts a numeric reason code in the third column. The data pairs in the first two…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,089 questions
asked 2024-07-29T02:26:24.69+00:00
Rich Goldberg 141 Reputation points
edited the question 2024-07-31T08:19:42.77+00:00
Emi Zhang-MSFT 24,361 Reputation points Microsoft Vendor
3 answers One of the answers was accepted by the question author.

whitespace query mystery

I am trying to identify ‘mismatches’ between a table of valid email addresses, and an employees table with an email address field. I’ve just been using the standard ‘find unmatched query wizard’ in Microsoft Access which has identified several…

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,517 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
863 questions
Office Management
Office Management
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Management: The act or process of organizing, handling, directing or controlling something.
2,089 questions
asked 2024-07-26T08:27:49.12+00:00
crib bar 821 Reputation points
edited the question 2024-07-31T08:15:51.8066667+00:00
Emi Zhang-MSFT 24,361 Reputation points Microsoft Vendor
1 answer

Why doesnt the checkbox result in a value of -1?

I am checking the boxes of these fields but for whatever reason the the value doesnt result in -1. Every single box i check returns a value of 0. What can I do so that I get the -1 value of a checked box. One thing to note is that the table from which…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
asked 2024-07-19T17:22:19.23+00:00
Lopez, Ahiezer 236 Reputation points
commented 2024-07-25T21:45:52.18+00:00
Duane Hookom 75 Reputation points
2 answers

populate a list box based on user input

Hello, I am not a programmer, I need to populate a list box based on user input. I have Access form that has 5 Entry fields, that user enter proper information in one field and selecting “Search” icon. Created 5 different queries that runs according to…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
863 questions
asked 2024-07-22T17:50:44.3933333+00:00
Radio Fixer 41 Reputation points
commented 2024-07-24T19:09:48.4866667+00:00
Radio Fixer 41 Reputation points
0 answers

The operation failed because of a registry or installation problem. Restart Outlook and try again.

I got an error "The operation failed because of a registry or installation problem. Restart Outlook and try again." on the last line of this simple procedure trying to execute .GetSharedDefaultFolder method: Public Sub xxx(Email As String,…

Outlook
Outlook
A family of Microsoft email and calendar products.
3,540 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
357 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,780 questions
asked 2024-07-18T18:50:10.17+00:00
Hugh Banyon 0 Reputation points
commented 2024-07-23T01:53:34.5966667+00:00
SokiGuo-MSFT 26,086 Reputation points Microsoft Vendor