336 questions with Access tags

Sort by: Updated
1 answer

If we are changing from Office 2016 Access runtime to Office 365 Access runtime, do we need to change the database.mdb file to the newer version of microsoft access ?

In MS Access 2016, we created a database , with the file called App1.accbd. Users run this using access runtime. i.e. they have a shortcut to MSAccess.exe ( the access runtime version), so that it opens App1.accdb. If we swap the access runtime version…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
asked 2024-07-01T16:51:00.0766667+00:00
Greg Booth 1,316 Reputation points
commented 2024-07-13T15:28:58.87+00:00
0 answers

Visual Studio 2022 unable to connect to excel

Hi Folks, I wish to connect to Excel sheet from my Visual studio 2022 however when I create a connection and ran it the following error was produced. I am running Win10 64bit. ERROR Exception from HRESULT: 0xC020801C Error at Package [Connection manager…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
Visual Studio Setup
Visual Studio Setup
Visual Studio: A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.Setup: The procedures involved in preparing a software program or application to operate within a computer or mobile device.
1,005 questions
asked 2024-07-13T03:00:10.69+00:00
Sebring 41 Reputation points
2 answers

How can I have this code run faster?

I have this code that is executed only when I open a form. I press a button that runs a macro and that macro simply opens the form. Once this form is opened, the code in the "On Load" event is triggered, this code can be seen below. This code…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 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.
852 questions
asked 2024-07-10T17:27:48.5333333+00:00
Lopez, Ahiezer 236 Reputation points
commented 2024-07-11T21:03:54.8233333+00:00
AlphonseG 196 Reputation points
1 answer

How do I access my account if My Authenticator was deleted and reinstalled and now requires me to do the same two-step verification process, when I'm unable to get on either device??.

I deleted and reinstalled my Authenticator app and it is still asking me to login, but it didn't save my account on the Authenticator app. Now the issue arouse that I can't verify on the app nor access my work account. How am I supposed to access my…

Microsoft Authenticator
Microsoft Authenticator
A Microsoft app for iOS and Android devices that enables authentication with two-factor verification, phone sign-in, and code generation.
6,029 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
Microsoft Entra Internet Access
Microsoft Entra Internet Access
A Microsoft Entra service that provides an identity-centric Secure Web Gateway that protects access to internet, software as a service (SaaS), and Microsoft 365 apps and resources.
18 questions
asked 2024-07-09T14:05:57.0933333+00:00
Jordan, Arianna 5 Reputation points
edited an answer 2024-07-09T14:49:03.78+00:00
Sandeep G-MSFT 16,521 Reputation points Microsoft Employee
1 answer

Access Europe User Group Meeting - Wed 3 July

The next Access Europe User Group meeting will be on Wednesday 3 July 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). We are pleased to welcome two presenters from Germany: Olaf Nöhring and André Minhorst. Olaf will…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 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.
852 questions
asked 2024-06-28T18:28:52.7133333+00:00
Colin Riddington 141 Reputation points
edited an answer 2024-07-08T12:11:40.9533333+00:00
Colin Riddington 141 Reputation points
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,268 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
Windows Server
Windows Server
A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.
12,568 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.
509 questions
asked 2024-04-19T01:28:50.96+00:00
Elham Khalaji 0 Reputation points
commented 2024-07-04T11:11:44.27+00:00
Chandrasekar N 0 Reputation points
0 answers

Your account has been locked

Your account has been locked. Contact your support person to unlock it, then try again

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
asked 2024-07-03T10:05:00.19+00:00
snof 0 Reputation points Microsoft Employee
3 answers

Error 3101 in Access 2013

I have an error 3101 message in my desktop database (Access2013). I do have a one to many relationship, but the "many" side does have a corresponding record on the "one" side, but I get the 3101 error anyway. How can that…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
asked 2024-07-01T20:09:32.73+00:00
Biorn Veiro 0 Reputation points
commented 2024-07-02T20:35:19.08+00:00
Biorn Veiro 0 Reputation points
0 answers

The expression On Open you entered as the event property setting produces the following error : Duplicate definition

Hello all I am Fouad from Baghdad I have an Access database that works on all versions of Office from version 2010 to the latest version in Arabic, and it works on Windows 10 and Windows 11 systems, but there is a laptop on which my database did not…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 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.
852 questions
asked 2024-07-01T21:11:13.6+00:00
Fouad Alshamy 0 Reputation points
1 answer

I lost my access to Minecraft

I bought Minecraft years ago from a gift card. I migrated my Mojang account to my Microsoft account and I could play with no problems for the time being. I played the last time like 2-3 days ago, and now I wanted to play Minecraft again. I can't.…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
asked 2024-06-30T10:46:23.02+00:00
Magdalena Rudnik 5 Reputation points
answered 2024-07-01T15:05:16.3533333+00:00
Schneider, Tobias 1,130 Reputation points
0 answers

Device management could not be enabled

Your account was not set up because device management could not be enabled. This device might not be able to access some resources such as wifi vpn or email

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
asked 2024-07-01T05:29:52.7133333+00:00
Mahalakshmi S 0 Reputation points
6 answers One of the answers was accepted by the question author.

Invalid procedure call or argument error

When pressing a command button the code below is executed, and it results in an error as seen in the picture. In addition, I seem to be the only user with this issue. My coworkers don't mention having this issue. I never had this issue until about a…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 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.
852 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,061 questions
asked 2024-06-04T21:28:57.5766667+00:00
Lopez, Ahiezer 236 Reputation points
edited the question 2024-07-01T02:56:55.8133333+00:00
Jiajing Hua-MFST 7,545 Reputation points Microsoft Vendor
0 answers

Error when changing DataSet from Access to SQL

I have a VB program that I wrote many years ago that used an Access database. The program has a DataSet that I originally created from the Access database. Recently, I tried changing the connection string it uses to point to a MS SQL Server Express…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
asked 2024-06-29T17:52:56.2233333+00:00
Gregory Greenman 0 Reputation points
0 answers

How to set up client permissions on secure shared database

Hi. I am building a database for a person who audits hospitals and so the database is shared, between her and another lady, on a very secure site. The problem we are having is when I program it to do something, like show P1 from a checkbox to say P1 or…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 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.
852 questions
asked 2024-06-21T14:37:39.87+00:00
CC 0 Reputation points
5 answers One of the answers was accepted by the question author.

External users without Microsoft account cannot access Sharepoint site

Hello, I have created a Sharepoint site within my organization, and within it I have created a series of folders and files to share with external people (I have enabled external sharing to users who do not belong to the organization, etc.). The problem…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
10,211 questions
asked 2024-06-18T10:55:17.8066667+00:00
SAT TECH 20 Reputation points
answered 2024-06-20T13:53:33.4866667+00:00
Mustafha Shariff 0 Reputation points
1 answer

How to stop sql_generate_invisible_primary_key generation when migrating Access database to Azure MySQL

After import of Access table to Azure MySQL instance database, an invisible primary key is automatically generated. 'SHOW VARIABLES LIKE "sql_generate_invisible_primary_key";' shows 'ON'. Trying to 'SET GLOBAL sql_generate_invisible_primary_key…

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
759 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
asked 2024-06-10T21:07:18.86+00:00
GScavello 0 Reputation points
commented 2024-06-18T23:48:41.63+00:00
GeethaThatipatri-MSFT 29,012 Reputation points Microsoft Employee
0 answers

Object variable or With Block variable not set

I have this code that is executed upon pushing a button. After going through most of the code i get an error saying 'Object variable or With Block variable not set'. Private Sub CancelJob_Click() On Error GoTo Err_Close_Jobs Dim BOM As String Dim i…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 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.
852 questions
asked 2024-06-18T16:01:14.43+00:00
Lopez, Ahiezer 236 Reputation points
commented 2024-06-18T16:44:58.51+00:00
Lopez, Ahiezer 236 Reputation points
0 answers

Bug in Access Database Compare Tool

Hello As seen in the screenshot: System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.ReportViewer.WinForms, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a' or one of its dependencies. The system cannot find the…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
asked 2024-06-17T15:11:21.3+00:00
StewartBW 825 Reputation points
0 answers

Jet compact utility

Hello Any idea why this download is not signed with a code signing certificate by Microsoft? https://learn.microsoft.com/en-us/office/troubleshoot/access/jet-compact-utility-download And, there's a password protected mdb database that I need to compact,…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 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.
852 questions
asked 2024-06-17T05:21:07.63+00:00
StewartBW 825 Reputation points
3 answers One of the answers was accepted by the question author.

Limit the rows in Access table

Hello Is it possible to limit the number of rows in each Access mdb database table? Will need to apply the limitation via VB.NET OLEDB and using Access database engine. Thanks.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
336 questions
VB
VB
An object-oriented programming language developed by Microsoft that is implemented on the .NET Framework. Previously known as Visual Basic .NET.
2,655 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.
852 questions
asked 2024-06-13T15:00:50.7033333+00:00
StewartBW 825 Reputation points
answered 2024-06-15T14:13:18.4+00:00
Ken Sheridan 2,756 Reputation points