I use a subform to show the result of a query, but at the end of record there is a *(New) for adding new records. I don't want the user to be able to add new records through this subform. How can I...

I'm writing a database in Microsoft Access to save the client from having to buy SQL Server. How do you get the primary key of the row that I just inserted? In SQL Server, it's INSERT INTO TABLE(...

I've had severas problems with strings in access-vba. The thing is, access (sometimes) limit the string's length to about 255 characters. However, depending on HOW the string was built, it may be...

I have a collection (employees) of employee that contain name, id, office, and officeto fields. I need to printout this information in equally spaced columns. So i need to find the length of the l...

I want to know the Select Query for MS Access with case sensitive. I have two values for VitualMonitorName as below VCode VirtualMonitorName Row 1 (1, 'VM1'); Row 2 (2, 'Vm1'); Here both values...

I need to add a calculated field to an existing table. I am aware of two ways to do this and I'm wondering if anyone has any input on which is best and how to make them work: Using TableDef.Creat...

I am working with MS-Access and JSP. I want to know that how can we create table with autonumber field and with primary key. query="Create Table Registration_A (Reg_No PRIMARY KEY AUTOINCREMENT,...

I've been doing a bit of research on this topic and I can't seem either find a workable solution, or one that is explained well enough for me to implement. If you've ever created a crosstab query ...

I'm attempting to use an Access database from a WPF MVVM application using JetEntityFrameworkProvider and I can't get it to work. I've created the models, created the migrations using Add-Migration...

What is the best way to perform bulk inserts into an MS Access database from .NET? Using ADO.NET, it is taking way over an hour to write out a large dataset. Note that my original post, before I "...

I was playing with some code online and tried the following in my project to disable default access ribbon Sub DisableStartupProperties() ChangeProperty "StartupShowDBWindow", dbBoolean, False ...

I have recently been introduced to the new Access 2007 feature which is multivalued fields. My initial impression is that it is a bad idea to make use of multiple values in a single field. Traditio...

I have an MS Access .mdb file, which I would like to convert into an SQLite database. I need to convert all the tables and dump the data inside. Are there any FOSS command-line tools that can do ...

This is not a progrmaing question, but I am sure MS Access developers will soon hit this problem Situation : PC has MS Office 365 Installed (Home or small Business version) which does not include ...

When I run mdb-export, the program dumps the comma delimited table to the terminal, but does not create a csv file as far as I can tell. Is mdb-export creating a csv file somewhere or is this dum...

I must read a MS Access in my ASP.NET Core application. The problem is, that OleDb is no longer supported in .NET Core. Is there another way to work with a MS Access database?

I'm trying to create a very simple form in an Access database. Whenever I drag a textbox on the form, a label gets created with it. I want to be able to move the label without moving the textbox,bu...

I am trying to access a file stored in a Microsoft Access database. (I am working in Visual Studio 2012) I chose the Database source type, and the Dataset database model, when it asks me "which dat...

I am trying to grab some football player data from a website to fill a privately used database. I've included the entire code below. This first section is a looper that calls the second function to...

In a Microsoft Access 2007 project the Access form objects are exported to files with a dedicated software by using the built-in function "SaveAsText". This is necessary because Access doesn't stor...

I want to create a navigation button on a web form. (I use MS Access 2010 - Web database). I dragged the button on the form (the Control Wizard option is selected) but the Command Button Wizard doe...

While struggling with a single legacy MS Access application I faced this weird error: Cannot open any more databases. The application makes extensive use of UNION sql statements. So this seems t...

I have a very simple form, that uses a very simple class to handle some things. And that class has a Class_Terminate sub to clean up after itself. However, that doesn't seem to be firing when the f...

I have an optional field in a database that I'm pulling out using a DAO Record Set. I need to check whether or not the field is set before I concatenate it with other fields. So far I have the foll...

I believe this issue is a result of a recent update to MS Office/Access or Windows 10. When I run this code: Dim s As String With CreateObject("Scriptlet.TypeLib") s = Left(.Guid, 9) newguidx = ...