848 questions with Access Development tags

Sort by: Updated
3 answers

How do I compare two access database tables, both the table has same rows and columns ?

I have two access database tables. Table A Account #, Name, Addres, City, State, Balance, Purchase, Order, Year, TotalCost Table B. Account #, Name, Addres, City, State, Balance, Purchase, Order, Year, TotalCost My purpose is to compare Table A and…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,565 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,646 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,562 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.
848 questions
asked 2024-02-13T06:46:20.43+00:00
Josh S 26 Reputation points
edited an answer 2024-02-29T22:16:58.11+00:00
Peter Doering 170 Reputation points MVP
3 answers One of the answers was accepted by the question author.

RefreshLink has started failing with Error 3611 - Version 2312 (Build 17126.20014)

Having posted in the Community forum, it has been suggested that this is a better place to ask my question. I have a split Access database that has started raising Error 3611 (Cannot execute data definition statements on linked data sources) in the…

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,205 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,680 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.
848 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,058 questions
asked 2023-12-08T22:47:02.6333333+00:00
DaveBWC 20 Reputation points
edited a comment 2024-02-28T00:36:16.2266667+00:00
Karl Donaubauer 1,726 Reputation points MVP
1 answer

MS Access 2019 Crashes - Exception 0xc0000005

I am attempting to upgrade an existing MS Access 2010 application, but I get intermittent silent crashes, typically when opening or closing a screen form. The Application Event Viewer logs the following typical details: Faulting application name:…

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.
848 questions
asked 2022-01-01T00:18:47.803+00:00
Craig Bransfield 1 Reputation point
commented 2024-02-26T17:17:02.2833333+00:00
GPE 51 Reputation points
1 answer One of the answers was accepted by the question author.

I got an error when using MSSMAA and cannot migrate to SQL Server

When I start MSSMAA i got an error: Starting conversion... Analyzing metadata... Converting table Samod_Relèves.[AMaTable_Elec] ... Information: A2SS0005: The Zero-length-not-allowed flag on the column 'ResultID' was converted to a check…

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.
848 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,058 questions
asked 2024-02-04T21:43:19.5533333+00:00
RENE COUZINIER 20 Reputation points
edited the question 2024-02-26T06:34:39.6033333+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

How to enter contributions records for different years. E.g 2010 to present

I am creating an MS Access file for welfare contributions for my local church. I have created a table to record the details of the contributions which includes, payment date, contribution month, contribution year, etc. I entered data for 2017 for example…

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.
848 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,058 questions
asked 2024-02-05T23:02:04.3766667+00:00
Enoch 20 Reputation points
edited the question 2024-02-26T06:34:20.9566667+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
3 answers

How do I implement VB code for Data Adapter & Adapter.Fill() using C#?

Dim con As New OleDb.OleDbConnection Dim dA As OleDb.OleDbDataAdapter Dim dS As New DataSet Dim selectCommand As String Dim dT As New DataTable selectCommand = "SELECT * FROM tblA" dA = New OleDb.OleDbDataAdapter(selectCommand, con)…

.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,565 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,562 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,642 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.
848 questions
asked 2024-02-19T07:47:53.5166667+00:00
Josh S 26 Reputation points
commented 2024-02-23T11:39:10.0866667+00:00
Jiachen Li-MSFT 28,001 Reputation points Microsoft Vendor
0 answers

Failed to create Relationship - Access Connector for Dataverse

If table migration fails partway through and you start again with the remaining tables, the migration wizard re-migrates related tables, even if they were already migrated, but with a "1" at the end. Then when the wizard attempts to create the…

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.
848 questions
asked 2021-12-03T00:00:32.117+00:00
Donna 16 Reputation points
commented 2024-02-23T00:36:15.59+00:00
William C. Roof 0 Reputation points
5 answers One of the answers was accepted by the question author.

MS Office 2019 - Temporary Word File in ..\INetCache\Content.Word are not trusted

I am running MS Office 2019 on a Windows 10 system. At some point in the 2nd half of 2022, I started to receive the message: Microsoft Office has identified a potential security concern. Microsoft has blocked macros from running because the…

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.
848 questions
asked 2023-01-04T19:10:40.857+00:00
Bill Meyers 66 Reputation points
commented 2024-02-19T11:59:37.4466667+00:00
Mikel AA 80 Reputation points
1 answer

DevOps readers cannot see any projects in the organisation I created. What am I doing wrong?

In Azure DevOps, I have created users with reader security permission, and basic access. But they cannot see any projects in the organisation. When they log in, they can see an organisation, but no projects, so they cannot go into anything. What am I…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
332 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.
848 questions
asked 2024-02-16T08:21:16.45+00:00
DavidKnight-3354 0 Reputation points
edited the question 2024-02-16T19:39:30.6866667+00:00
QuantumCache 20,186 Reputation points
2 answers

I lost my two-factor authentication program and can't access my account now

I lost my two-factor authentication APP INCLUDING TO MOPILE FORMAT and can't access my account now

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.
5,954 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.
848 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,058 questions
asked 2023-09-21T23:08:18.1+00:00
ahmed ATTALLA 10 Reputation points
commented 2024-02-14T00:12:59.61+00:00
Raul Guerrero Deschamps 21 Reputation points
2 answers

Access Europe Meeting - Wed 7 Feb

The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE add-in MZ-Tools, Carlos Quintero, will be leading a…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
332 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.
848 questions
asked 2024-01-30T16:44:15.35+00:00
Colin Riddington 85 Reputation points
answered 2024-02-10T16:05:35.95+00:00
Colin Riddington 85 Reputation points
1 answer

IIS / ODBC / user permission

Hello, With Windows server 2009 / IIS 10 / ODBC 64 / Classic ASP i experience a problem : We have an internat website (Intranet) for our company, In global.asa i open ODBC connection : Session_Start : Set Myconn =…

Internet Information Services
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
332 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.
848 questions
asked 2024-01-31T17:23:16.07+00:00
Didier CLAPIER 0 Reputation points
commented 2024-02-07T02:21:29.0333333+00:00
Albert Kallal 5,226 Reputation points
2 answers

ACEOLEDB.DLL from Microsoft 365 Apps crash with Exception code 0xc0000005

ACEOLEDB.DLL from Microsoft 365 Apps (at least versions 16.0.14228.20248, 16.0.14430.20006, 16.0.14701.20040 in "C:\Program Files\Microsoft Office\root\VFS\ProgramFilesCommonX64\Microsoft Shared\OFFICE16\") appear to cause an application crash…

C++
C++
A high-level, general-purpose programming language, created as an extension of the C programming language, that has object-oriented, generic, and functional features in addition to facilities for low-level memory manipulation.
3,608 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.
848 questions
asked 2021-12-29T20:18:30.603+00:00
Jmenninkainen 31 Reputation points
commented 2024-02-06T16:52:56.73+00:00
Bart Geuens 0 Reputation points
1 answer

MS 365 ACCESS 64 bit , JRO.JetEngine , Class not registered

Hi On Windows 10 , MS 365 ACCESS 64 bit I can add reference to Microsoft Jet and Replication Objects 2.6 Library: C:\Program Files\Common Files\System\ado\msjro.dll Set oJe = CreateObject("JRO.JetEngine")  , Error: Class not registered After…

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.
848 questions
asked 2024-02-03T15:58:05.9466667+00:00
PACALA_BA 1 Reputation point
edited an answer 2024-02-03T17:34:01.15+00:00
Albert Kallal 5,226 Reputation points
2 answers

Erro Code: 40315

Good night dear. I have a problem creating my account as a developer, here is the error that is happening: We can't continue with the signup process for the following reason: MS-CorrelationId: 00000000-a268-45a6-bcc1-c6c8b735353b Code: 40315

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,205 questions
Windows 365 Enterprise
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,680 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.
848 questions
asked 2024-01-11T23:01:31.26+00:00
Bruno Fernandes 25 Reputation points
edited the question 2024-02-02T09:07:34.53+00:00
Srinivasa Rao Darna 6,711 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

My Access 365 works on my windows 10 pc, but when I put it on a windows 10 laptop with 64 Runtime it wont run

I have an Access 365 program that works on my Windows 10 PC, but it won't run when I put it on a Windows 10 laptop with the 64-bit Runtime it won't run. The laptop does not have Microsoft 365, so it needs the runtime. The laptop ran a 32-bit runtime…

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,680 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.
848 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,058 questions
asked 2024-01-24T11:53:26.0566667+00:00
Alex Gobran 20 Reputation points
edited the question 2024-01-31T06:53:48.5266667+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
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…

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.
848 questions
asked 2022-02-16T22:18:41.207+00:00
Mathias Z 1 Reputation point
edited an answer 2024-01-30T19:49:45.4266667+00:00
Albert Kallal 5,226 Reputation points
1 answer

How to unblock Microsoft Access files?

I would like to find out how to unblock Microsoft Access files. That way I can do my school work.

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
11,047 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
332 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.
848 questions
Windows 10 Security
Windows 10 Security
Windows 10: A Microsoft operating system that runs on personal computers and tablets.Security: The precautions taken to guard against crime, attack, sabotage, espionage, or another threat.
2,815 questions
asked 2024-01-30T00:13:36.39+00:00
Rose L Price 0 Reputation points
edited an answer 2024-01-30T10:46:32.1166667+00:00
Karl Donaubauer 1,726 Reputation points MVP
1 answer

Gain Access to account

The Admin for our clarity account has left the business, how can we regain access to the account as we currently can't do anything with it and the scripts are effecting our site speed?

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.
848 questions
asked 2024-01-29T13:11:03.7433333+00:00
Robert Adair 0 Reputation points
answered 2024-01-29T13:50:12.9266667+00:00
Adharsh Santhanam 2,320 Reputation points
1 answer

Tengo una base de datos .accdb que no me abre me da un error

Estuve trabajando en la base de datos la cerré y al querer abrirla para seguir trabajando me sale el siguiente error ".. no se reconoce como una base de datos..". Hay alguna forma para recuperar lo ya hecho. Gracia por su respúesta

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.
848 questions
asked 2024-01-23T01:06:43.31+00:00
Antonio Lopez 0 Reputation points
answered 2024-01-24T15:58:22.8+00:00
Daniel Alejandro Rivera Dominguez 410 Reputation points Microsoft Vendor