1,240 questions with Access-related tags

Sort by: Updated
Updated Created Answers
2 answers

I CANNOT CREATE CALCULATED FIELD BECAUSE OF PROBLEM WITH MaxLocksPerFile

N° Fields I have a database in Access with about 130 fields. ACCESS and LOCATION The Access file is in a shared folder, just because it really is, but only I use it, no one else goes in. PROBLEM When I want to create a calculated field the following…

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.
899 questions
asked 2025-02-18T00:22:04.7733333+00:00
Luis Angel Ñañez Llanos 256 Reputation points
answered 2025-02-19T09:55:06.2533333+00:00
Karl Donaubauer 2,056 Reputation points MVP
0 answers

I cannot use the sandbox with my account

I created a Sandbox space to practice. Yesterday I could use it but today it ias asking for a suscription, even if the default directory has a suscription.

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
asked 2025-02-19T09:52:04.42+00:00
Ana Álvarez 0 Reputation points
3 answers

SSMS Import of MS Access accdb external component has thrown an exception (System.Data)

I've been using SQL Server Management Studio for some time to import tables from MS Access into SQL Server. Now I get an error External component has thrown an exception. (System.Data) when I choose an Access database to import from. This worked only a…

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,490 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
asked 2024-12-10T09:58:07.5066667+00:00
Richard Williams 15 Reputation points
commented 2025-02-18T19:22:56.72+00:00
Awais_Saad 0 Reputation points
1 answer

giving a user access to a shared file , approving access still not working

giving a user access to a shared file , approving access still not working

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
2,175 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
11,233 questions
asked 2025-02-17T15:34:04.6+00:00
Chrishaun Douglas 0 Reputation points
answered 2025-02-18T10:06:43.4466667+00:00
Emily Du-MSFT 50,326 Reputation points Microsoft Vendor
2 answers One of the answers was accepted by the question author.

Will Microsoft Access have an End-of-Life? If so, when?

I am inquiring about the End of life for Microsoft Access in Office 365 products suite. Please provide dates as to end of life and end of support. Thank you!

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
asked 2024-01-26T18:04:32.2033333+00:00
Brenda Edders 30 Reputation points
edited an answer 2025-02-17T14:45:11.6766667+00:00
George Hepworth 0 Reputation points
1 answer

Use VBA to delete all appointments in a day of Outlook

From MS Access 365 I need to use VBA to automatically delete all appointments for a specific day in the Calendar of Outlook. I can access the specific Calendar using the following command Set nsCalendar = nsMAPI.Folders("Specific Outlook…

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.
5,771 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.
899 questions
asked 2025-02-15T07:19:55.55+00:00
John Papaioannou 21 Reputation points
commented 2025-02-17T12:27:57.65+00:00
George Hepworth 0 Reputation points
2 answers

MIGRATE DATABASE TO ACCESS 365

Migrate 2013 Access database to Office 365 and share it with a group

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
asked 2025-02-14T16:08:06.16+00:00
Radise Lucas 0 Reputation points
commented 2025-02-16T15:17:04.5733333+00:00
Sasha Froyland 1 Reputation point
0 answers

Un-enrolling device from company portal when you don't have access to the email

I recently switched companies and when setting up the Outlook app on my iphone for the new company I received the following alert. "Your admin wants the apps on this device to me managed with the account (old email). The app account you are using…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
asked 2025-02-13T20:20:01.0466667+00:00
Owen, Bishop 0 Reputation points
2 answers

Microsoft Access latest documentation

Hello, Where can i find the latest document on MSFT's Access DB ? thanks, Cooper

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
asked 2025-02-13T00:40:21.57+00:00
HomerAlpha 6 Reputation points
answered 2025-02-13T15:16:35.6533333+00:00
George Hepworth 0 Reputation points
1 answer

How to fix Automation error Object is not connected to server

I have an MS Access database with a table that has an OLE Object type field. The field stores a PowerPoint slide associated with the rest of the data in the record. I have a form with a bound object frame for the OLE Object field. There is a Button on…

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.
899 questions
asked 2024-12-02T17:17:17.8866667+00:00
William Sessums 0 Reputation points
answered 2025-02-03T18:50:56.7466667+00:00
Courtney Owen 0 Reputation points Microsoft Employee
2 answers

How to program with Edge navigateur object?

How can we use the Edge Navigator control to send a message to copilote and save the information?

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.
899 questions
asked 2025-01-30T15:44:58.8666667+00:00
NGUYEN Alain FG/DACRG 0 Reputation points
answered 2025-01-31T13:23:07.38+00:00
George Hepworth 0 Reputation points
2 answers One of the answers was accepted by the question author.

how to fix "Failed to load microsoft.date.sqlclient version = 5.0.0.0 file or assembly..."

I tried to recreate projects, installed the access engine, added microsoft.data.sqlclient through nuGet, installed various database extensions, watched a lot on the Internet, nothing helped. I need to add an access database. What should I do?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
11,307 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.
899 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
11,307 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.
899 questions
asked 2025-01-28T12:32:37.71+00:00
Efrem 20 Reputation points
commented 2025-01-29T11:29:53.3633333+00:00
Efrem 20 Reputation points
2 answers One of the answers was accepted by the question author.

how to fix "Failed to load microsoft.date.sqlclient version = 5.0.0.0 file or assembly..."

I tried to recreate projects, installed the access engine, added microsoft.data.sqlclient through nuGet, installed various database extensions, watched a lot on the Internet, nothing helped. I need to add an access database. What should I do?

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
11,307 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.
899 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
11,307 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.
899 questions
asked 2025-01-28T12:32:37.71+00:00
Efrem 20 Reputation points
commented 2025-01-29T11:29:53.3633333+00:00
Efrem 20 Reputation points
4 answers

Microsoft Access - Sytax Error in JOIN operation

I am struggling with an access database. I cannot figure this out. I keep getting a "Syntax error in JOIN operation" error. Can someone please help me? Below is the SQL data. SELECT Courses.course_name ,Venues.venue_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.
899 questions
asked 2025-01-26T22:49:43.7733333+00:00
Harley Kronikxz 0 Reputation points
edited a comment 2025-01-28T16:47:56.3233333+00:00
Ken Sheridan 2,851 Reputation points
1 answer

How to set up client permissions on secure shared database

Hi. I am building a database for a person who audits hospitals and so the database is shared, between her and another lady, on a very secure site. The problem we are having is when I program it to do something, like show P1 from a checkbox to say P1 or…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
899 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
899 questions
asked 2024-06-21T14:37:39.87+00:00
CC 0 Reputation points
commented 2025-01-28T15:16:53.07+00:00
George Hepworth 0 Reputation points
1 answer

How to set up client permissions on secure shared database

Hi. I am building a database for a person who audits hospitals and so the database is shared, between her and another lady, on a very secure site. The problem we are having is when I program it to do something, like show P1 from a checkbox to say P1 or…

Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
899 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 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.
899 questions
asked 2024-06-21T14:37:39.87+00:00
CC 0 Reputation points
commented 2025-01-28T15:16:53.07+00:00
George Hepworth 0 Reputation points
1 answer One of the answers was accepted by the question author.

Can I use ODBC Driver for SQL Server after Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 ?

I am using ODBC Driver for SQL Server version 18 to connect to an Azure SQL Database Can I use ODBC Driver for SQL Server after Azure SQL Database 2014-04-01 APIs will be retired on 31 October 2025 ?

Azure SQL Database
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
asked 2025-01-28T08:21:46.43+00:00
Sigurd Grønvigh - Tromek Produksjon AS 20 Reputation points
accepted 2025-01-28T09:23:48.5866667+00:00
Sigurd Grønvigh - Tromek Produksjon AS 20 Reputation points
1 answer

What is the most current Microsoft Jet Database Engine version and how to get the installer package?

We have a legacy software written in VB6, which stores a lot of data in various Access database files. Getting recordsets are working, but getting the values from fields causes problems for some of our customers. For the majority it works fine, but for…

Windows 10
Windows 10
A Microsoft operating system that runs on personal computers and tablets.
12,078 questions
Access
Access
A family of Microsoft relational database management systems designed for ease of use.
423 questions
Windows 11
Windows 11
A Microsoft operating system designed for productivity, creativity, and ease of use.
10,789 questions
asked 2025-01-24T10:30:54.6133333+00:00
VASARI Akos 0 Reputation points
commented 2025-01-24T14:27:33.9666667+00:00
VASARI Akos 0 Reputation points
1 answer

CopyFromRecordset Automation Error

ExcelSheetPopulate.txtI had been running Office 2016 MSO (16.0.12624.20278) 32-bit for several years. I've been using the attached code in MS Access for the past 5 years without any issue. Suddenly, getting Error 430, 'Class does not support Automation…

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.
4,275 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.
899 questions
asked 2025-01-20T15:49:08.4033333+00:00
AlphonseG 201 Reputation points
edited the question 2025-01-21T02:12:15.2366667+00:00
Emi Zhang-MSFT 27,961 Reputation points Microsoft Vendor
2 answers

CodeContextObject / Converted Macro

I receive the following error: Run-Time error 2467 The Expression you entered refers to an object that is closed or doesn’t exist. And the following line is highlighted in my code: Set objCurrent = CodeContextObject Can anyone assist with me with…

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.
899 questions
asked 2021-03-31T17:47:13.377+00:00
imodett 61 Reputation points
answered 2025-01-19T16:58:23.1033333+00:00
Gustav 717 Reputation points MVP