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
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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.
![](https://techprofile.blob.core.windows.net/images/oZy-DvHL5UC1mJTFG3q7Zw.png?8D8D1D)
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…
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 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…
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 ???",…
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 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…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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…
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…
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…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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…
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…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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…
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…
![](https://techprofile.blob.core.windows.net/images/8o5q2cUO40CjLP1q1W828Q.png?8D929B)
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…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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…
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…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)
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…
![](https://techprofile.blob.core.windows.net/images/xgCloIrQvUeqYfAqQE8a0A.png?8D8342)