I have created a lookup table in Access to provide the possible values for a column. Now I need to update this column with the data it had before I converted the column. I am unable to figure out a...

I know this question has been asked a few times in various context, but I have not found a clear answer. I have email implemented for an access application using outlook, but I'd like to move away ...

In the course of a complex database structure, I need to provide the user with a means of editing data stored in a series of tables. Although all the data types are the same, they don't line up 1:1...

I am running a few modules of VBA code. In the middle of running the code crashes as Access reaches its max size of 2GB; but, if I compress the database at that point it is only 200MB. Is it poss...

I have an odd issue with a form I have in MS Access. For some reason, when I hit the "enter" key within a text box, the cursor moves to a different text box. What i am looking to happen is for the ...

I have a Autoexec macro setup on a Access 2016 database to determine which form to open based on Environ("USERNAME"). When I open the database I get a macro Error 2001. If I click Stop All Macros,...

I have a table where one of the fields can be empty. I'm trying to return only these rows where this field is empty. But I keep getting errors just doing WHERE field = "" ... WHERE field = '' ... W...

What are the maximum concurrent connections ms-access supports?

I have a recordset rst with 2 columns/fields ID and Value. The recordset has multiple rows. While debugging, I am able to view records in the first row of the recordset in the immediate window usin...

I would like to retrieve the records in certain dates after d/mm/yyyy, or after d/mm/yyyy and before d/mm/yyyy, how can I do it ? SELECT date FROM table WHERE date > 1/09/2008; and SELECT da...

I am using visual studio community 2017 Access 2010 - 2016 I can import an access file I created File sent from client contains(tables, queries, forms, macros, and modules) Provider=Microsoft.ACE....

Using Access 2010. I have a query with several Memo fields in it that I would like to export to an Excel sheet. Every method I have tried so far has truncated the Memo fields: Export Wizard Right...

I need to create a table in MS Access, then append columns with DATES as the field names based upon a user-provided date range (StartDate, EndDate), like this: LastName | FirstName | Role | 10/01/...

So I have used doCmd.TransferText many times to use a saved text import specification, as you can easily saved the file path returned from an Application.FileDialog(msoFileDialogFilePicker) to find...

I have a *.MDB database file, and I am wondering if it is possible or recommended to work against it using LINQ in C#. I am also wondering what some simple examples would look like. I don't know a...

I've been working on a project using the LAMP server that requires frequent read of the MS-ACCESS database, stored in *.mdb file. The database has one table and about 40.000 rows in it. I've insta...

I have used vba code in Windows 32 bit. Now that I've migrated to Windows 10 64 bit I got the message "The code in this project should be updated for use on 64-bit systems. Please review and update...

I am attempting to transfer specific columns from an excel document to specific columns to a table in my Access database. For example my excel sheet might contain the following: Date Last First Ge...

Sub btn1_Click() Static value As Integer value = value + 1 MsgBox value End Sub I swear when I was taking a VB.net course in college there was a shorter way to tell a variable to add '' to itself...

I am currently using following code to export data from worksheet to MS Access database, the code is looping through each row and insert data to MS Access Table. Public Sub TransData() Applica...

While connecting one applet to an Access DB using the jdbc:ucanaccess method, I get the following error: Firstdb.java:44: error: unreported exception SQLException; must be caught or declared to b...

I have database in MsAccess 2007 having 5 Tables inside them I want to create View in MS Accesss I dont need Syntax, but i need Step to create View (because i cant find CreateView in MS Acccess

Iam using ms access as a database .mdb file how to get the ms access drivers 2007 . i got the error :The 'Microsoft.ACE.OLEDB.14.0' provider is not registered on the local machine.

Does anyone have any experience of using Access 2007 with the prior versions of Access (i.e. mdb files). We have been upgraded, but are still using the mdb format. Some of our code (in particular ...

I am using the OpenArgs parameter to send a value when using DoCmd.OpenForm: DoCmd.OpenForm "frmSetOther", acNormal, , , acFormAdd, acDialog, "value" I then use Me.OpenArgs inside the opened for...