211 questions with Access Development tags

Sort by: Updated
2 answers One of the answers was accepted by the question author.

How to create with Visual studio a deployment for an Access project

Good morning, I have an Access 365 project and I would like to create an installation project of it using visual studio 2022. I would like some information on how to do it. It's possible? Thank you Marco Dell'Oca

Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,806 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.
846 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,053 questions
asked 2024-06-15T14:50:59.2366667+00:00
Marco Dell'Oca 141 Reputation points
edited the question 2024-06-27T05:52:34.68+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
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.
325 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,640 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.
846 questions
asked 2024-06-13T15:00:50.7033333+00:00
StewartBW 745 Reputation points
answered 2024-06-15T14:13:18.4+00:00
Ken Sheridan 2,756 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.
325 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.
846 questions
asked 2024-06-04T21:28:57.5766667+00:00
Lopez, Ahiezer 236 Reputation points
accepted 2024-06-12T18:28:09.0066667+00:00
Lopez, Ahiezer 236 Reputation points
2 answers One of the answers was accepted by the question author.

How to insert a new reference in an excel projet

Good morning, I have a Ms Access project that creates a new Ms Excel project and inserts data into a sheet. I need to insert a new reference in the created Excel project. I want to insert a reference to Ms Access to be able to invoke a Ms Access form.…

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.
846 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,677 questions
asked 2024-06-02T15:13:41.3166667+00:00
Marco Dell'Oca 141 Reputation points
accepted 2024-06-03T16:25:22.3066667+00:00
Marco Dell'Oca 141 Reputation points
2 answers One of the answers was accepted by the question author.

access copy and paste issue

We have a strange intermittent issue in an Access 2016 database application (classic architecture with individual front end per user with links to a central backend database), that prevents users copying text from emails, word docs, xlsx spreadsheets etc…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,426 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
325 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,671 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.
846 questions
asked 2024-03-08T08:21:54.9866667+00:00
crib bar 781 Reputation points
accepted 2024-06-03T11:58:50.84+00:00
crib bar 781 Reputation points
1 answer One of the answers was accepted by the question author.

Integer equivalent in Access

Hello I work with Access mdb with OleDbRader (Access Database Engine) in vb.net and need to set the data type to Integer (NOT Long Integer) so: Dim cmd As New OleDbCommand("ALTER TABLE Blah ALTER Column colm ???",…

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,543 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,640 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.
846 questions
asked 2024-05-26T01:35:55.2433333+00:00
StewartBW 745 Reputation points
accepted 2024-05-26T21:35:04.4533333+00:00
StewartBW 745 Reputation points
3 answers One of the answers was accepted by the question author.

Form Filter returning no records causes Error 2185: Can't reference a property for a control unless the control has the focus

I have a continuous form with a simple query as the data source. In the form header I have an unbound control into which the user types a partial search string. In the onChange for that control I update the form filter dynamically. This all…

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.
846 questions
asked 2021-11-02T00:26:50.213+00:00
James Garrison 236 Reputation points
edited an answer 2024-05-26T12:19:27.73+00:00
Non Linear 0 Reputation points
3 answers One of the answers was accepted by the question author.

Access VBA References caused compile error

An Access database in Microsoft Office 365, which is up to date, uses references to several other programs, selected in the Tools | References menu in the VBE. It has compiled successfully for several months as it is developed. It then suddenly failed…

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.
846 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,053 questions
asked 2024-05-08T17:38:21.3566667+00:00
Andrew Collins 61 Reputation points
edited the question 2024-05-14T01:53:37.35+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
1 answer One of the answers was accepted by the question author.

Execution Context for MS Access front end to SQL Server backend

Hello, we have a business application that is based on MS Access front end and SQL Server backend. Tables are linked via DNS-less connection. The application is using SQL Server Authentication using an ODBC connection, driver is SQL Server (connection…

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,160 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.
846 questions
asked 2024-04-18T01:50:05.6266667+00:00
MKinOZ 31 Reputation points
commented 2024-04-24T01:12:34.9033333+00:00
MKinOZ 31 Reputation points
2 answers One of the answers was accepted by the question author.

ADD Column will not show CheckBox

Hello, Using Access database engine + oledbreader on mdb, this code will add a new boolean yes/no column: New OleDbCommand("ALTER TABLE BlahTable ADD Column BlahOption BIT NOT NULL", strConnection) :: ExecuteNonQuery This will add a yes/no…

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,543 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,640 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.
846 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,053 questions
asked 2024-04-03T02:01:31.49+00:00
StewartBW 745 Reputation points
commented 2024-04-12T20:43:06.4766667+00:00
Albert Kallal 5,226 Reputation points
2 answers One of the answers was accepted by the question author.

Office Access Refactoring

Hey, In our company we've a legacy software based on Office Access. We have access to the accdb-File with all sources. This software is connected to a SQL-Server Database. We want to tidy up our database therefore we need to now which columns are used by…

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.
846 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,053 questions
asked 2024-04-09T14:07:03.8+00:00
Fabig, Richard 20 Reputation points
edited the question 2024-04-12T00:40:06.8366667+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

mdb/accdb to use with Access database engine

Hey I need to create an Access database in Office Access and make the tables and fields, then deliver the blank file with the vb.net app which will use Access database engine 2010 and OleDbRerader to work with the database. Just need to decide between…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
325 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,640 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.
846 questions
asked 2024-03-28T13:53:33.89+00:00
StewartBW 745 Reputation points
accepted 2024-03-29T10:53:40.9166667+00:00
StewartBW 745 Reputation points
3 answers One of the answers was accepted by the question author.

summary report for blank values per field in access

We have a large table of data (several thousand records), and a significant amount of fields is recorded for each record. The design of the table means at present some fields are mandatory (required), and others are not required – which I think was…

Office
Office
A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.
1,426 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
325 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.
846 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,053 questions
asked 2024-03-11T12:58:39.2+00:00
crib bar 781 Reputation points
edited the question 2024-03-18T08:13:02.63+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor
9 answers One of the answers was accepted by the question author.

msaccess.exe (all versions) won't close properly when process EoAExperiences.exe is running

I have a msaccess-application (accdb) working as frontend-client to a sql-server database. The FE-database consists of forms, reports, modules, etc. On one client, when I open a form with controls others than label, it is not possible to close 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.
846 questions
asked 2022-01-03T09:40:05.007+00:00
Christoph Schweizer 36 Reputation points
commented 2024-03-05T18:31:41.23+00:00
Cyclobiker 0 Reputation points
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,179 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,671 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.
846 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,053 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 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.
846 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,053 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.
846 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,053 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
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.
846 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
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,671 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.
846 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,053 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
1 answer One of the answers was accepted by the question author.

How to connect an Access 2010 database to a SQL Server database on a seperate computer

Hi All: I have a Microsoft SQL Server database stored on a separate computer MRM-WINX-002. I wish to create a Microsoft Access 2010 frontend (GUI) and have it link to the selected database on the server computer. Does anyone have illustrated Step-by-Step…

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,160 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
325 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.
846 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,053 questions
asked 2024-01-19T15:33:23.1466667+00:00
Mark McCumber 431 Reputation points
edited the question 2024-01-23T07:49:20.8433333+00:00
Emi Zhang-MSFT 23,271 Reputation points Microsoft Vendor